SAP ABAP2XSLX . excel sheet with multiple header line using field catalog

[former_member216437]

Hi All,

I need to design excel sheet with multiple header using Field catalog.. I am using abab2xslx for creating excel sheet.. I am exporting data to excel from internal table...

Is it possible to get multiple header line in excel sheet using abab2xslx?.

Is there any other suggestions to achieve this?

Please find attached image for reference.

img-20180925-092042.jpg

Thank & regards

Sathish Mani

[patrick_sojka]

Hallo Sathish,

you could use worsheet->bind_table to add your table. Set is_table_settings-top_left_row to skip some Rows.

Then loop over your structure fields (assign component...) and use worksheet->set_cell to set your multiple Headerlines.

Regards,

Patrick