on 06-09-2015 5:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.