in reply to Re^2: Spreadsheet::XSLX parsing workbook, but not retrieving values from cells
in thread Spreadsheet::XSLX parsing workbook, but not retrieving values from cells

But when using Spreadsheet::Read, you should also use the methods that Spreadsheet::Read provides and not use the methods the undelying parser might use. That defeats the purpose of the wrapper.

First install Spreadsheet::ParseXLSX and then read the file using the right syntax:

use strict;
use warnings;

use Spreadsheet::Read;

my $excel = ReadData ("xyz.xlsx");
defined $excel or die;

print "Read with ", $excel->[0]{parser}, "\n";

[download]

Regarding the quotes, that might be a cut-n-paste (windows) problem. The post of your code shows the use of "smart"-quotes “ U0201c \N{LEFT DOUBLE QUOTATION MARK} instead of plain duoble-quote ".


Enjoy, Have FUN! H.Merijn

Replies are listed 'Best First'.
Re^4: Spreadsheet::XSLX parsing workbook, but not retrieving values from cells
by divyahk (Initiate) on Sep 18, 2014 at 10:38 UTC

    Hi,

    Thanks for the suggestion. I tried using Spreadsheet::ParseXLSX to read the file, and it seems to work just fine.

    So I think this problem is solved, but has taken me to the next problem which is that my file seems too big and therefore causes some kind of segmentation fault. That, according to the documentation, is to be expected for extremely big files.

    Any suggestion on using another library for bigger files?

    Thanks!

[reply]

In Section Seekers of Perl Wisdom