how to import excel file in bods?
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.