Skip to Content
0
Aug 16, 2023 at 06:41 PM

Downloading excel with Merged cells in sapui5

118 Views

hello everyone,

I'm currently working on a requirement related to downloading Excel data from the sap.ui.table. Specifically, if the TrainId is the same for all the CarId. I've managed to download the table data using the sap.ui.export.Spreadsheet API reference in sap sdk. however, the requirement demands that cells should merge during the downloading process, based on Trainid. in the case where the trainId is identical(same) for all the CarIds, the trainId cell should merge.

API reference

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

Expectation output

image.png

if anyone who worked on this requirement please let's know your solution to this issue

Attachments

image.png (28.9 kB)