cancel
Showing results for 
Search instead for 
Did you mean: 

how to download a dynamic generated table to excel.

Former Member
0 Kudos

Hi all,

I have req where i need to download the contents of table whose columns are generated dynamically.Please help me in this, i used the exporttoexcel2003() fun for static colmuns, is there any other posibility to do this.

Please help me in this regards

Regards,

Sai sharan

Accepted Solutions (1)

Accepted Solutions (1)

former_member751941
Active Contributor
0 Kudos

Answers (2)

Answers (2)

Former Member
0 Kudos

Why should there be a difference for "dynamically" created columns? You export the data from the context node not the table columns of the UI.

Armin

Former Member
0 Kudos

Hi ,

The thing is will be able to export data for static cloumns, coz i have there column headernames. But in dynamic columns i'll get the headers from database and i dont know how to use this dynamic columns headernames in headername to excel sheet of the excel to be export.Moreover even in the static columns table. the column names in the excel is coming in jumbled fastion so wanted to know if there is some other means of doing this.

please help me in this regard

Sharan

Former Member
0 Kudos

Yes, it's possible to extract the WDP table content to the Excel. Why not try try POI HSSF?

- julius

Former Member
0 Kudos

can u please help me with some code sample so thta i canbe able to complete that.will be thank full

Former Member
0 Kudos

just loop through the node and create CSV file, it can be open as excel.