Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Uploading data from MS-XL to local db.......

hi all,

i have a doubt while uploading data from XLS to my local database in DI-API.....In the below coding iam uploading data from the path Bin>Materials->Item1.xls, to my local db....here i have to hard-code the XL file name...is there any method by taking the XL file dynamically.....

FileName = System.AppDomain.CurrentDomain.BaseDirectory() & "\MATERIALS\Item1.xls"

     rs = oCompany.GetBusinessObject(BoObjectTypes.BoRecordset)
            objExcel = CreateObject("Excel.Application")
            objWrkBk = objExcel.Workbooks.Open(FileName)
            objSht = objWrkBk.Worksheets(1)

Regards,

shangai.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question