Reading in merged cells from Excel XLSX

[jdudleyh]

I'm using Spreadsheet::XLSX to read in an Excel 2010 file. Unfortunately it doesn't appear to handle merged cells the way I thought it would (only first cell has the value).

Spreadsheet::XLSX talks about populating some of the classes from Spreadsheet::ParseExcel, but it apparently did not include is_merged()

P.S. I'm trying to avoid XLSX to XLS conversions.

[Tux]

Spreadsheet::XLSX is kinda unmaintained. Sadly, so is the alternative Spreadsheet::ReadSXC. Though imho the alternative shows better conformance to Spreadsheet::ParseExcel than the first one does.

The author of Spreadsheet::ParseExcel has plans to write Spreadsheet-ParseExcelXML for XLSX, but that is delayed because of Spreadsheet-WriteExcelXML iirc.

You could try to draw the author's attention by commenting on this ticket, preferably with a patch to make the module do what you want conforming to the behavior in Spreadsheet::ParseExcel.

[runrig]

The author of Spreadsheet::ParseExcel has plans to write Spreadsheet-ParseExcelXML for XLSX, but that is delayed because of Spreadsheet-WriteExcelXML iirc.

The write excel library is Excel-Writer-XLSX, but I don't know if that has anything to do w/the slowness of the reader development. The reader Excel::Reader::XLSX is under development, and is somewhat usable, though in an alpha state. And I don't know how it handles merged cells.

[jdudleyh]

Thanks H.Merijn. I'll add a comment on that bug report as soon as I figure out how to comment on that bug report. :)

The patch shouldn't be too hard to write either.