I have 4 years of experience in implementation and developing Addons of B1 8.81, 8.82.
Consisting need of reading the data from Excel sheet and using it in SAP B1, I have defined steps to be followed for reading excel sheet data.
I know that SAP has given ASAP methodology but in this blog am going to explain it in differ way.
Purpose of the BLOG:
How to read contents of Excel sheet by SAP B1 Addon. Sometimes, While preparing GRPO, my Client had to enter Serial numbers of many Items. Their suppliers used to provide them that data in excel format also.
So I have developed addon to read the data from excel sheet
'1. I have created one Button on Serial Number Setup window, on Button click event I have called method showOpenFileDialog which calls other method.
Public Function showOpenFileDialog() As String
Dim ShowFolderBrowserThread As Threading.Thread
ShowFolderBrowserThread = New Threading.Thread(AddressOf ShowFolderBrowser)
If ShowFolderBrowserThread.ThreadState = System.Threading.ThreadState.Unstarted Then