#!/usr/bin/perl -w
#use Text::CSV_XS;
use strict;
use warnings;
use lib '/home/users/kulshrk/perl_module/lib64/perl5';
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, ">", "Project_status_tracking_DFT.csv" or die "Project_status_tracking_DFT.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)
{
#

 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];
  my $value;
 if ($source_cell)
   {
local $Text::Wrap::columns = 20;
$value = wrap ("", "", $source_cell->Value);

}   
push @row , $value;

}

$csv->print ($fh, \@row);
  
}
}
close $fh;