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?
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.