Report merged cells from XLSX

Question

Report merged cells from XLSX

Closed this issue 3 years ago · 5 comments

davidmegginson commented 3 years ago

Report if an XLSX contains merged cells.

Requested by USAID, via Dan.

Answer 1 · 2022-05-06T15:24:33.000Z

Here is the call to xlrd3 that returns the info: https://pythonhosted.org/xlrd3/sheet.html#Sheet.merged_cells

Answer 2 · 2022-05-06T15:54:21.000Z

The strategy will be to create a class hxl.model.MergedCell where __str__ returns the empty string, then constants hxl.model.MERGED_CELL_LEFT, hxl.model.MERGED_CELL_UP, and hxl.model.MERGED_CELL_BOTH (also available in hxl.*), which will be the value of any empty cell that's merged from above, from the left, or both.

Answer 3 · 2022-05-06T15:57:10.000Z

At first, we'll support only in Excel, but later we can add Google Sheets.

Answer 4 · 2022-05-06T15:58:11.000Z

Will need to add more magic methods to the MergedCell class to support comparisons.

Answer 5 · 2022-05-15T16:02:59.000Z

Reopening. It turns out that the MergedCell object will break JSON serialisation, so going to take a different approach, building it in as an option for raw input rather than downstream.