Exporting Data into Excel Query

[slinc]

We use Business Objects InfoView / Web Intelligence. The problem is when we download to Excel, any static labels on the report do not get transferred into Excel, only the contents of the data providers.

Does anyone know a way of getting Business Objects to export all the data (including static labels) into Excel?

Any help would be much appreciated.

 

[pabloj]

I usually export to html, which is handled well by excel Stick to your guns

 

[skrandel]

Or save your reports as .text. It can be CSV that loads in just fine.

In V6, Save As Excel will be there. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[slinc]

Many thanks for the feedback. Managed to export as .txt, and then open in Excel which keeps all the static data.

 

[funkmonsteruk]

Got some vba code that does all of this in a single step:

sub Export()

dim doc as document
dim rep as report

set doc=application.documents.item(1)
set rep=doc.reports.item(1)
rep.exportastext("File sting goes here" & ".xls&quot
end sub

works like a dream and you can even add
doc.refresh
application.quit
lines to get the code to run automatically when the document is opened if you want to limit user interaction