CuriousOne CuriousOne - 4 years ago 109
Perl Question

can't merge cells after table creation with Excel::Writer::XLSX

If I try to merge two cells say C7 and C8 after a table is created in excel, the data, format gets corrupted. All the table formatting vanishes. Is it a limitation of the module?

Answer Source

Is it a limitation of the module?

No. It is a limitation of Excel. You cannot merge cells in a table.

Nevertheless, Excel::Writer::XLSX should probably issue a warning or prevent this from happening. I'll look into that.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download