Export Excel with multiple Headers Using Spreadsheet in SAPUI5

[former_member494689]

Hi Experts,

Is it possible to configure the columns to show the following result using spreadsheet in SAPUI5?

If yes, kindly let us know the sample/reference. Thanks.

To export excel, I refered this link. But, it is just one line header and no merge cells.

https://sapui5.hana.ondemand.com/sdk/#/entity/sap.ui.export.Spreadsheet/sample/sap.ui.export.sample....

Best Regards,

Thiri

[felipe_dimmu23]

Hi Thiri,

Yyou can use class sap.ui.export.Spreadsheet to set up a lot of things in a custom export to excell button of yours, but if I understood correctly, as explained in this, grouping headers is not possible.

Regards,

Felipe

[former_member494689]

Hi Felipe,

Thanks for your feedback.

Yes, I am using sap.ui.export.Spreadsheet.

I also found no sample documents or blogs for merge header cell pattern yet. 😞

Best Regards,

Thiri

[former_member494689]

Hi Felipe,

If you know any other ways, please let us know.

Thank You.

Best Regards,

Thiri