search

doy / spreadsheet-parsexlsx

parse XLSX files
http://metacpan.org/release/Spreadsheet-ParseXLSX
27 stars 35 forks source link

identify merged cells and areas #10

Closed rolaf closed 10 years ago

rolaf commented 11 years ago

And, for now, my last issue:

In my Spreadsheet::ParseExcel based programs I do use the cell method is_merged() and the sheet method get_merged_areas() a lot in order to identify a merged cell and to fetch the value from the top-left-most cell in the corresponding merged area. Spreadsheet::ParseXLSX does not (yet?) provide an interface to identify merged cells & areas.

I have created a separate testcase for that: https://dl.dropboxusercontent.com/u/80321078/ParseXLSX/ParseXLSX-Merge.tgz

How Spreadsheet::ParseExcel behaves: script: test_merge_xls.pl (uses spreadsheet Book1.xls as input)

How Spreadsheet::ParseXLSX behaves: script: test_merge_xlsx.pl (uses spreadsheet Book1.xlsx as input)

In order to find me a solution I took the freedom to implement a corresponding interface to ParseXSLX.pm (probably not the cleverest implementation though). You can find my modified version here: https://dl.dropboxusercontent.com/u/80321078/ParseXLSX/ParseXLSX.pm.modif

doy commented 10 years ago

Thanks, fixed!

doy commented 10 years ago

Released in 0.09.