cancel
Showing results for 
Search instead for 
Did you mean: 

Export to Excel in WAD

Former Member
0 Kudos

Hi All,

i need to have the export to excel option from WAD.

I could get the steps from "How To..." guide called Web Printing with Microsoft Excel

i need to download two files and copy those to Sub Directory Co Files of DIR_TRANS directory.

from referring in SDN i could get the below link for downloading,

https://websmp102.sap-ag.de/~sapdownload/011000358700001853752005E/HowToWebPrintingWithExcel.zip

but I cannot go to the link for the zip file. I got Error Message - ObjectID not existant . Perhaps the address has changed,

please help ...

regards,

NR

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Pls try this link.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b1089290-0201-0010-288c-98e4d264...

Put this in your HTML part of the Web Template.

<TD

href="<SAP_BW_URL DATA_PROVIDER=Query name' CMD='EXPORT' FORMAT='XLS' > Export to Excel /TD>

Just try this.

Former Member
0 Kudos

Hi,

Are you using WAD 3.5 or 7.0.

If you are on WAD 3.5, then you can use the following command:

SAP_BW_URL DATA_PROVIDER='View1' CMD='EXPORT' FORMAT='XLS'

If you are on WAD 7.0, you have inbuilt commands:

Place a Link item or a button. In its properties, then use command through Command via Command --> define the command --> in the pop-up, select All Commands --> Command for Web Template --> Export Web Template --> Bind the Data Provider in the next pop-up --> Export format Excel. (by default it is PDF).

Hope this helps.

Former Member
0 Kudos

Hi Vishal,

I m in BW 3.5, can you please let me know the steps in detail.

do i need to give this option in WAD template HTML Code...??

do i need to add a new web item (Button for Export to excel)...??

where do i need to add this command

SAP_BW_URL DATA_PROVIDER='View1' CMD='EXPORT' FORMAT='XLS'

please let me know the detail steps

Regards,

Pradeep.