Export to Excel.

[Former Member]

Hello,

Did anybody come across a problem how to transport data from SAP Table into Excel spreadsheet using ABAP WebDynpro?

Thank you.

[thomas_jung · Accepted solution]

Have you tried looking at the ALV component instead of the standard table UI. One of the additional functionalities of the ALV component is the built in ability to download to Excel.

Otherwise you might be able to adapt the following to WDA:

/people/thomas.jung3/blog/2004/09/02/creating-a-bsp-extension-for-downloading-a-table

You really only need the logic in the PROCESS_XML_DOWNLOAD

section.

It isn't as nice as the ALV Download. The ALV component transforms the table into XML so that it retains some formatting. This solution just converts an ABAP internal table into a text, tab-delimited string.

[thomas_szcs]

Hi Georgy,

You can use the Web Dynpro OfficeIntegration to achieve this. There is a OfficeControl ui element, which allows Excel files to be displayed and manipulated.

Best regards,

Thomas

[Former Member]

Hello Thomas,

What if I have a standard SAP table (hierarchical or not) and "Export to Excel" button. I do not want to see Excel document. I view the table and hit "Export to Excel" button, select a location on a hard drive where I want to save this excel file.

Could you please clarify?

Thank you.

[RichHeilman]

Sounds like the "File Download" ui element. Have you checked into that?

Regards,

Rich Heilman

[Former Member]

Hello,

I am trying to determine how much effort it takes to save content of an SAP table into an Excel spread sheet.

File download sounds exactly what I need but how complicated is it to implement this feature?

Thanks.

[RichHeilman]

Not sure if this will help.

http://help.sap.com/saphelp_nw04/helpdata/en/c8/32cc6922fb6040a768652aaa0b6879/content.htm

REgards,

Rich Heilman

[Former Member]

Hello Rich,

The link you provided is about Java WebDynpro.

I am interested in ABAP WebDynpro.

Thanks.

Georgy

[RichHeilman]

Oh yes, very sorry. Try this one.

http://help.sap.com/saphelp_nw04s/helpdata/en/09/a5884121a41c09e10000000a155106/frameset.htm

Regards,

Rich Heilman

[thomas_szcs]

Hi Georgy,

>File download sounds exactly what I need but how

>complicated is it to implement this feature?

One additional note regarding downloading files. In Web Dynpro ABAP there is the possibility to attach files to a response without having the need to use a FileDownload ui element. Just call CL_WD_RUNTIME_SERVICES=>ATTACH_FILE_FILE_RESPONSE.

Best regards,

Thomas

P.S: Try Thomas Jung's suggestion first. Using the ALV seems to be the best way to solve your issue.

[Former Member]

PS: And here's the link to the documentation about file export without FileDownload that Thomas mentioned:

http://help.sap.com/saphelp_nw04s/helpdata/en/13/a1764299d76255e10000000a155106/frameset.htm

Regards, Heidi