Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Reading in merged cells from Excel XLSX

by jdudleyh (Novice)
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
Re: Reading in merged cells from Excel XLSX
by Tux (Monsignor) 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
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (6)
As of 2014-09-21 15:20 GMT
Find Nodes?
    Voting Booth?

    How do you remember the number of days in each month?

    Results (172 votes), past polls