Use Data-OLEDB Business object :
1. Set Connection --> Provide connection string Ex: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;Extended Properties="Excel 8.0;HDR=YES";
2. Open Connection
3. Then Use the Action "Get Collection" with the Query "select * from [Sheet1$]" output will be BP collection
4. Close Connection
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.