Download to Xls or XLSX Row grouping

[nagarjun_kalletla]

Hi Experts,

I have to download data from Table Ui element . The downloaded file has to show data

in the grouping format.

For example;

Interanl table contains fields : Customer Number and sales Order, Amount,

Customer Number sales Order Amount

1000                     120000001   3000.30

1000                     120000002   3400.00

1001                     122000001   2000.00

1001                     122000002   3440.00

After it downloaded the Excel should contains only two line(by dfaultt)

+    1000                120000001  3000.30

+    1001                 122000001 2000.00

When you click on symbol(+)  then hidden rows will shown.

We can do it in Excel by using Group. Just select few rows(row number 1 to 5) and then go to

DATA->GROUP AND OUTLINE->GROUP.

Then u will see one line for the selected rows.

Can anybody tell me how to achieve it in ABAP Webdynpro using classes.

Thanks In advance.

Regards,

Nagarjun

[former_member219762]

Hi Nagarjun,

                 Add a TableColumnGroup in the table ui element, add columns (on basis of which columns do you want merge rows ) to TablecolumnGroup and bind the groupingValue propety to corresponding element of context node.

Regards,

Sreenivas.

[nagarjun_kalletla]

Hi Sreenivasa Rao ,

What you have said is perfectly right , when binding to Table UI element.

When I click on Download in below picture I want to get the Data to Excel as it is . 

Need your valuable Input.

Thanks In Advance

Nagarjun

[former_member219762]

Hi Nagarjun,

                  I hope this will help.

http://scn.sap.com/docs/DOC-25024

Regards,

Sreenivas.