on 05-28-2013 2:32 PM
Hi all,
I'm wondering if it's possible to export a BO report to Excel (doesn't matter which version) without any kind of format, I mean, with no header, with no colors, etc.
Thanks,
Alberto
Hi,
You cant do this , if you save as Excel , you will get the report how it looks in Webi, only HJeader and Footer will not come.
You can save as txt or csv , and then import it in Excel, this will work.
Thanks,
Avi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, You can export WebI report to Excel and report headers and footers wont be exported into excel.
Thanks,
Jothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Open your BO Webi report in modify. Go to the "Save" icon and select "Save As to my computer" drop down list and select .csv. The result will be the raw data selected for the the BO query. It will not have any formating, sorts, highlight, charts etc. I've have not encountered duplicate columns in my extracted data unless I've pulled in 2 separate objects with simalar results, such as claim header date of service and claim line date of service.
Hi Alberto, Try save as .csv instead of .xls. This can be opened in excel and will not have any formatting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.