The problem was in the autofilter() function
I use Perl 5.12.4 so not sure what to do to make the xlsx support autofilter method. They claim it is not fully supported.
Have you ever received this error?
Can't locate object method "_quote_sheetname" via package "Excel::Writ
+er::XLSX::Worksheet" at C:/Perl/lib/Excel/Writer/XLSX/Worksheet.pm li
I checked my code 100x times and still cannot see what would be the source of this problem. My program should print out 3 sheets in a file but gets stuck before the 2nd sheet.
my $workbook = Excel::Writer::XLSX->new($xlsfile);
# Add a worksheet
my $worksheet = $workbook->add_worksheet( 'Inputs');
my $format1 = $workbook->add_format( %font_basic );
my $worksheet2 = $workbook->add_worksheet('Results');
If I update their code then it complains about this method:
I appreciate your help.