Export excel mergeCells

#1

MergeCells after exporting to Excel:思維:思維:思維:

#2

Hi,

Can you add more details? Example and reproduction steps

Best,
Wojciech

#3

I want to merge cells in excel after exporting excel

image
image.png990×534 25.5 KB

#4

This depends on your implementation for export to Excel functionality. Our exportToFile plugin exports only CSV, and by the specification for CSV format it does not support merged cells.

If you’re using any 3rd party library to create XLSX file then you will need to feed it with merged cells. This information can be obtained from the merge cells plugin.

Do you have an example of your exporter?

#5

I understand, but I currently use the exported package as “js-xlsx.js”. I need to use the exported Excel to connect with the overlap. It does have the function of merging the cells, but it needs to be opened in Excel to save it Here.

image
image.png929×699 35.4 KB
image
image.png927×492 26.8 KB

#6

Hey @rty12345678928

as Wojciech said before, we only allow to export data via .CSV file while does not allows ut to share meta data (like styling, custom renderers or merged coordinates). You get only what you see via getData() method.

#7

You can get rowspan and colspan from cellMeta. We do exactly the same in parseTable helper:

#8

Thanks

#9