How To Export Table Data in a View to Excel Sheet and Save Excel Sheet

[Former Member]

Hi Experts,

I tried alot to export the table data into excel sheet. i have seen many threads posted and also i tried to do that using sample codes (zip files) available in SDN. I couldnt able to do that.

Please guide me with the correct procedure with all the steps....

Thanks in Advance.

[Former Member · Accepted solution]

HI

I hope there is Export to Excel project already available , you can use that directly .

May be you can use the Export to Excel projects component.

[Former Member · Accepted solution]

Hi All

Thanks for all your Advices

Now i am Successfully Wxporting the Table Values to Excel .. I have Used WDExport_Excel.zip available in SDN-

But the PROBLEM is,

When the Table Contains only One row - When It is Exported to Excel, I am NOT getting ColumnNames (MetaData) in the Excel Sheet ( Only data is Coming)

Help me out of this Problem

Thanks in Advance

[Former Member · Accepted solution]

hi

we have also faced the same problem .

there will be node which set the data to the Excel .

just above that set the blank values to the same node .

your problem will be solved .

[Former Member]

Hi Challa,

me too want the same functionality that is download table data to excel sheet. so could you please give me the path of WDExport_Excel.zip .

thanks

anand

[siddharth_jain]

Hi,

Check the blog:

https://www.sdn.sap.com/irj/scn/wiki?path=/x/0mq

Sample project is attached in the Blog ,it is applicable for NW 7.0

Siddharth

[Former Member]

Tell me your email ID I'll send you the project

Thanks

[Former Member]

This message was moderated.

[Former Member]

Hi,

Chack this article:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a9...

It describes how to achieve the functionality required by you.

Regards.

Rajat

[Former Member]

Hi,

May be of use for you https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d0cc41cb-9576-2b10-99a6-ab90ef28...

Regards

Ayyapparaj

[Former Member]

HI

this link i have seen already. could u please explain in detail

thanks