Download complex data to excel

[Former Member]

Hi all,

I have a view with 5 different tables in a special order. (special layout)

Now I want to download the tables to excel with this special layout.

I try to use the I_IO_SPREADSHEET interface.

But it seems that this is not working in WDA.

What else can I use to create dynamic excel files using WDA?

regards

Wolfgang

[Former Member]

Hi,

the easy way would be to define your tables as ALV's, then just make use of the export to excel functionality that comes freely with ALV's. You'd have to download/export each table separately, though. And it would not be very dynamic... not sure what you mean by "dynamic", btw. Are you changing the contents/columns/other aspects dynamically during the program flow?

Regards,

Trond

Edited by: Trond Stroemme on Aug 2, 2011 3:38 PM

Edited by: Trond Stroemme on Aug 2, 2011 3:39 PM

[Former Member]

Hi,

your recommendation is not possible.

All the tables have no toolbar because of the special layout.

The tables show different data and are positioned in a special way.

Table 2 Table3

XXXXXXX XXXXXXX

XXXXXXX XXXXXXX

Table 1 Table 4 Table5

XXXXXXX XXXXXXX XXXXXXX

XXXXXXX XXXXXXX XXXXXXX

XXXXXXX XXXXXXX XXXXXXX

Table2 should be under table4 and table3 under table5.

The columns and rows are dynamically. The tables will be created at runtime.

I want to extract this view to the excel file.

So I need something like I_IO_SPREADSHEET for WDA.

Regards