BusinessObjects Board

export report to Excel

sdk development
#1

Hi,
Is it possible to export a report generated by WebI 2.7 to Excel format?

Thanks
Sree

KSreedhar (BOB member since 2003-12-18)

#2

Yes, it should be possible to export to a format that Excel recognizes. (I believe it’s actually *.csv but you could easily convert it to *.xls if you need to.)

I don’t have a 2.7 install here, but if I remember correctly, there’s an “Export” command up at the top of the report. (Might be called “Export Data.”) I’m not sure of the SDK equivalent.

Good luck,
Judy

JMulders :us: (BOB member since 2002-06-20)

#3

Hi Judy,
Thanks for ur response.
I didn’t find any link or button in WebI for exporting it to Excel.
Moreover i’m using WebI SDK (WIBean) for generating the reports on the browser.
so is thera any api or method in that which can do that? (i know there is method for the opening the report in the PDF format. in the same manner i need it for excel.)

Thanks
Sree

KSreedhar (BOB member since 2003-12-18)

#4

Hi Sree,

Have you looked at the Code Samples area? This looks close:

Good luck,
Judy

JMulders :us: (BOB member since 2002-06-20)

#5

I believe export to excel option available in version 6
There is no webi sdk for converting to excel in webi27, may be in webi6
If you want only data in excel from webi27 doc then read and write into csv file, sorry i’m not familiar with webi sdk.

you can opne any document in pdf from webi,
not microsoft products :cry:

Shahubar Sadiq :india: (BOB member since 2003-02-28)

#6

The only way you have is to save it as HTML. You can change TopBarResults.WIZ and include some onload=“executeCommand(…);” DHTML statement. That’s perhaps the easiest way I’ve found so far. But, graphics would not come out as Excel does not send back the cookie - and the interpretation of HTML by Excel will be rather disappointing.

HTH,

M

M :de: (BOB member since 2003-11-25)