CODEWITHSUNDEEP
excelperlexception
user3035061
user3035061

Reputation: 11

Compilation error when running perl code to access xlsx sheet

I have the below code:

use strict; 
use warnings; 
use Text::Iconv; 
use Spreadsheet::XLSX; 
use Date::Format;

my $converter = Text::Iconv -> new ("utf-8", "windows-1251"); 

# Read the data from a file.
my $prod_otp = Spreadsheet::XLSX->new('/home/shahk/Book1.xlsx', $converter);   
if (!defined $prod_otp ) { 
   die $prod_otp->error(), ".\n" ; 
}

But, when I try to run, I get the below error: 

Argument "#REF!" isn't numeric in int at /tools/oss/packages/Spreadsheet/XLSX/Fmt2007.pm line 94.

Can someone please help me out in overcoming this kind of error?

Thanks!

Upvotes: 0

Views: 781

Answers (1)

user3035061
user3035061

Reputation: 11

Adding parser Spreadsheet::XLSX::Fmt2007 worked. I decided to add this parser as the error it was showing was in the routine sub FmtString { } . atleast, now when I run the script I dont see this error

Upvotes: 1

Related Questions