我有以下代码:
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" ;
}
但是,当我尝试运行时,我会得到以下错误:
Argument "#REF!" isn't numeric in int at /tools/oss/packages/Spreadsheet/XLSX/Fmt2007.pm line 94.
有人能帮我克服这种错误吗?
谢谢!
添加解析器电子表格:XLSX::Fmt2007。我决定添加这个解析器,因为它显示的错误在例程子FmtString{}中。至少,现在当我运行脚本时,我没有看到这个错误