Question: how to import excel in bods?
Answer: 4) Go to Business Objects Data Services and click on the Formats option tab available at the Local Object Library. 5) At the Formats option go to the Excel Workbooks option and do a right click and select New option. 6) A new Import Excel Workbook window opens up.