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
Replies are listed 'Best First'.
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 rifling through the Monastery: (11)
As of 2015-07-30 21:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (273 votes), past polls