Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Reading in merged cells from Excel XLSX

by jdudleyh (Acolyte)
on Jul 30, 2013 at 18:29 UTC ( #1047091=perlquestion: print w/replies, xml ) Need Help??
jdudleyh has asked for the wisdom of the Perl Monks concerning the following question:

I'm using Spreadsheet::XLSX to read in an Excel 2010 file. Unfortunately it doesn't appear to handle merged cells the way I thought it would (only first cell has the value).

Spreadsheet::XLSX talks about populating some of the classes from Spreadsheet::ParseExcel, but it apparently did not include is_merged()

P.S. I'm trying to avoid XLSX to XLS conversions.

  • Comment on Reading in merged cells from Excel XLSX

Replies are listed 'Best First'.
Re: Reading in merged cells from Excel XLSX
by Tux (Abbot) on Jul 31, 2013 at 06:10 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.

      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?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1047091]
Approved by kevbot
Front-paged by kevbot
[stevieb]: choroba my GPS home device is done, at least prototype v1 is. I'm just making sure all of my code does what it says now
[stevieb]: I test/prototype code on my Pi, then I migrate it over to Arduino when it's ready (if that's a better platform for what I'm doing). The whole RPi stuff was for learning at first, then it snowballed. I'm just trying to get my in-house CI...
[stevieb]: ...done, which obviously requires a specific hardware setup.
[stevieb]: I don't write tests for the lower-level distributions (ie. ICs, sensors etc) within those distributions, I have all tests in a master distribution which encompasess all of the sub-modules

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (6)
As of 2017-06-25 22:56 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (572 votes). Check out past polls.