Default Excel Format

[Former Member]

Hi Team,

We have a situation wherein we have to schedule webi reports in excel format in BI 4.1 environment. We used to do the same in BO XI 3.1 SP3 version.

- The reports were scheduled in BO XI 3.1 SP3 in excel format (.xls)

- This excel was sent as input to a macro

- The macro is used to process the excel

However, in BI 4.1 region, the report is scheduled to excel format(.xlsx) This report cannot be sent as input to macro, as macro fails to process the excel.

Is there any way which will help us to schedule the webi report in .xls format. (We tried renaming the report to .xls format while scheduling, however, this did not worked.)

Thanks for your help in advance.

Regards,

Mitesh Joshi

[DellSC]

There are two types of Excel export from Webi in 4.1 - Excel and Excel 2007.  I suspect that you need to do an Excel 2007 export to get to the .xls format.

-Dell

[Former Member]

Hi Dell,

However, Excel 2007/Excel schedules the report to .xlsx format. Is there any way code change/jar file change, which will let us to schedule the report to .xls format.

Regards,

Mitesh Joshi

[DellSC]

Which SDK are you using to schedule the reports?  I believe you can do this using the new RESTful web services SDK.

-Dell