Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Reading in merged cells from Excel XLSX

by Tux (Monsignor)
on Jul 31, 2013 at 06:10 UTC ( #1047175=note: print w/ replies, xml ) Need Help??


in reply to Reading in merged cells from Excel XLSX

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.


Enjoy, Have FUN! H.Merijn


Comment on Re: Reading in merged cells from Excel XLSX
Re^2: Reading in merged cells from Excel XLSX
by runrig (Abbot) on Jul 31, 2013 at 16:54 UTC
    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.

Re^2: Reading in merged cells from Excel XLSX
by jdudleyh (Novice) on Jul 31, 2013 at 22:43 UTC

    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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1047175]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2014-08-02 02:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Who would be the most fun to work for?















    Results (53 votes), past polls