-------- SHEET:Projects Undefined subroutine &main::csv called at XLS2CSV.pl line 40. #### #!/usr/bin/perl -w #use Text::CSV_XS; use strict; use Spreadsheet::ParseExcel; use Text::CSV_XS; my $csv = Text::CSV_XS->new ({ binary => 1, eol => "\r\n", auto_diag => 1 }); open my $fh, ">", "file.csv" or die "file.csv: $!"; my $sourcename = shift @ARGV or die "invocation: $0 \n"; my $source_excel = new Spreadsheet::ParseExcel; my $source_book = $source_excel->Parse($sourcename) or die "Could not open source Excel file $sourcename: $!"; my $storage_book; foreach my $source_sheet_number (0 .. $source_book->{SheetCount}-1) { my $source_sheet = $source_book->{Worksheet}[$source_sheet_number]; print "--------- SHEET:", $source_sheet->{Name}, "\n"; next unless defined $source_sheet->{MaxRow}; next unless $source_sheet->{MinRow} <= $source_sheet->{MaxRow}; next unless defined $source_sheet->{MaxCol}; next unless $source_sheet->{MinCol} <= $source_sheet->{MaxCol}; my @sheet = (); foreach my $row_index ($source_sheet->{MinRow} .. $source_sheet->{MaxRow}) { my @row= (); foreach my $col_index ($source_sheet->{MinCol} .. $source_sheet->{MaxCol}) { my $source_cell = $source_sheet->{Cells}[$row_index][$col_index]; if ($source_cell) { push @row, $source_cell->Value; #print "( $row_index , $col_index ) =>", $source_cell->Value, ","; # print $source_cell->Value, ","; } } push @sheet, @row; } csv-> (in => @sheet, out => 'file.csv'); #print "\n"; }