Format Excel Table With Larger Row Height

[#1]

I am having an issue with the display of my data in Excel. I have exported my data from a sap.m.table and it displays as follows:

As you can see, the rows seem to be a set height and the text does not wrap in the columns. What I would like is to have the text wrap and not have the text overlap into the next column and for the rows to expand based on the length of the text. Something like this:

I am writing this in SAPUI5. Any help would be greatly appreciated! Thanks!

[Joseph_BERTHE1]

Be aware of one thing, the export feature of the table is only to export data as brut one. Especially it is used to functional guys who want to manipulate those data.

If you want a full capability of export feature with manipulate at cells level then you should use an external plugin such as : https://github.com/SheetJS/js-xlsx to add in your project and do what ever you want as formating or others things.

Kind Regards,

Joseph

[Former Member]

Okay, makes sense. Thank you very much for your time!

[Joseph_BERTHE1]

hi,

Have you seen this examle : https://ui5.sap.com/#/entity/sap.ui.export.Spreadsheet/sample/sap.ui.export.sample.formatting/code/S...

It is not regarding the rows but it handles the export processing. You can probably find some stuff for your requirement.

Regards,

Jospeh

[Former Member]

Yeah I've looked at these examples, but none seem to deal with text wrapping. None of the columns have long enough text like in my situation.