Skip to Content
avatar image
Former Member

Export to Excel in WAD

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 17, 2008 at 02:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Oct 17, 2008 at 02:44 PM

    Hi,

    Pls try this link.

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

    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.

    Add comment
    10|10000 characters needed characters exceeded