#!/usr/bin/perl -w
#use Text::CSV_XS;
use strict;
use Spreadsheet::ParseExcel;
use Text::Wrap;
#use Text::CSV_XS;
use Text::CSV_XS qw( csv );
#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 <source file>\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;
my $sheet = [];
foreach my $source_sheet_number (0 .. $source_book->{SheetCount}-1)

#use Text::CSV_XS qw( csv );

{
#

 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;
  }
use Text::CSV_XS qw( csv );

csv(in => $sheet, out => 'file.csv'); 

}