Hi Corion I am using the below code and calling the subroutine by specifying below stated property use Text::CSV_XS qw( csv ) but still I am getting same error Please find my script

#!/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->{Max
+Row})
 {
  my $row= [];
  foreach my $col_index ($source_sheet->{MinCol} .. $source_sheet->{Ma
+xCol})
  {
   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'); 

}
[download]

Error: experiment2 % perl XLS2CSV.pl Project_status_tracking_DFT.xls --------- SHEET:Projects Undefined subroutine &main::csv called at XLS2CSV.pl line 48.

Create a small test program for the part that is failing

#!/usr/bin/perl
use strict;
use warnings;
use Text::CSV_XS qw( csv );
print "$^V - $Text::CSV_XS::VERSION";

my $sheet = [['a','b','c,d'],[1,2,3]];
csv(in => $sheet, out => 'file.csv');
[download]

poj

Hi Poj

Thanks a lot ! I have to install the Text::CSV in my local directory After installing the module , I could able to eradicate the above stated error.

Thanks Kshitij