in reply to Spreadsheet::ParseXLSX question on merged cells
important to note that merged ranges are stored at the worksheet level, not on a per cell basis. You can get a merged range with my @mergedRange = $worksheet->get_merged_areas(); which will give you the four coordinates defining the merged range in the form of ($start_row, $start_col, $end_row, $end_col).
Important to note that the data will only be stored in top left cell of a merged range, so if the cell is in the merged range, you would be able to access its data at $start_row, $start_col
|
|---|