Spreadsheet-XLSX reviews

cpanratings
 

RSS | Module Info | Add a review of Spreadsheet-XLSX

Spreadsheet-XLSX (0.13-withoutworldwri)

I am getting below error and i didnt found any kind of solution to resolve this issue .

When i tried uploding file through web for further parsing on server using Spreadsheet::XLSX.pm , i got into below error.

Would like to know what can be the solution for his issue .

Cannot open as Zip archive at /d00/apps/local/lib/perl5/site_perl/5.8.8/Spreadsheet/XLSX.pm line 33.

Spreadsheet-XLSX (0.13-withoutworldwri) ****

Very userful for quick setup of a parser of XLSX files.

With reference to the review below complaining about dates, I mention that there is a package with the all the necessary funcitons: Spreadsheet::XLSX::Utility2007.

Spreadsheet-XLSX (0.13-withoutworldwri) **

I'm having problems with extracting XLSX dates. The default underlying date number is useless to me. I'm sure there's a simple way to get the formatted date, but the sparse and cryptic documentation doesn't help.

Spreadsheet-XLSX (0.13-withoutworldwri) ****

This is a decent module, but it's not as flexible or featureful as one might hope. However, it does the most important things. I hope to see this continue to expand, but work on improving it seems to be moving slowly.

Also, if you want to use it with uploads to a web page, you'll have to make sure and save the file first because it depends on Archive::Zip needs seekable file handles, which is not really the fault of this module.

Spreadsheet-XLSX (0.13-withoutworldwri) ****

Great initial cut. I used to export from excel as text to be read into perl every time I updated - tedious.
Two quibbles: if the XLSX file contains any #REF cell errors, this is echoed to STDERR with no option I can find to ignore these (or to track where they came from). The error says:
Argument "#REF!" isn't numeric in int at /usr/local/share/perl/5.10.0/Spreadsheet/XLSX/Fmt2007.pm line 94
Another one that comes up from something I can't locate within the XLSX file is:
Argument "<row r="697" spans="1:32">" isn't numeric in int at /usr/local/share/perl/5.10.0/Spreadsheet/XLSX/Fmt2007.pm line 94
I'm not *aware* of any spans (merged cells?) at the reported row; anyway again I'd like the module to trap these issues in reading the XML without printing to STDERR.
Second problem: cells containing accented characters are coming up as blank after I've read their Cell->{Val} into a perl variable (while all the non-accented ones come through fine). I assume this may be an issue with different character sets or encodings used, but I can't find a way to read this type of data successfully with this module.
The inability to read text with accents is really holding me up. Should this module be able to parse cells whose text includes UTF8 accent characters?

Spreadsheet-XLSX (0.04) *****

A great start for 0.0 release! It was easy to extend and make it more functional and rounded out. Be prepared to write some Perl if you are using this, but it saved me many days of coding!

Spreadsheet-XLSX (0.13-withoutworldwri) ****

Useful for reading xlsx files. Would be great if it could both read and write xlsx.
1 hidden unhelpful review