in reply to Re^9: Excel to CSV datetime conversion- format changes
in thread Excel to CSV datetime conversion- format changes

Able to get rid of the previous error.

Can't locate object method "get_cell" via package "Spreadsheet::ParseExcel" at ./perl_excel_xls2n.pl line 22.

#!/usr/bin/perl -w # For each tab (worksheet) in a file (workbook), # spit out columns separated by ",", # and rows separated by c/r. use Spreadsheet::ParseExcel; use Spreadsheet::ParseExcel::Utility qw(ExcelFmt); use strict; my $file='output2.csv'; my $datefmt = 'dd/mm/yyyy'; # ISO 8601 open STDOUT, ">", $file or die "$0: open: $!"; open STDERR, ">&STDOUT" or die "$0: dup: $!"; my $filename = shift || "/home/etc/srcfile.xls"; #my $e = new Spreadsheet::ParseExcel; my $excel = Spreadsheet::ParseExcel->new(); my $eBook = $excel->Parse($filename); my $sheets = $eBook->{SheetCount}; my ($eSheet, $sheetName); my $cell = $excel->get_cell( $eSheet->{row}, $eSheet->{col} ); my $value = $cell->value(); foreach my $sheet (0 .. $sheets - 1) { $eSheet = $eBook->{Worksheet}[$sheet]; $sheetName = $eSheet->{Name}; #print "#Worksheet $sheet: $sheetName\n"; next unless (exists ($eSheet->{MaxRow}) and (exists ($eSheet->{Max +Col}))); foreach my $row ($eSheet->{MinRow} .. $eSheet->{MaxRow}) { foreach my $column ($eSheet->{MinCol} .. $eSheet->{MaxCol}) { if (defined $cell->{Type} && $cell->{Type} eq 'Date') { $value = ExcelFmt($datefmt, $cell->{Val}); } if (defined $eSheet->{Cells}[$row][$column]) { print $eSheet->{Cells}[$row][$column]->Value . ","; } else { print ","; } } print "\n"; } }

Replies are listed 'Best First'.
Re^11: Excel to CSV datetime conversion- format changes
by marto (Cardinal) on Apr 25, 2014 at 11:08 UTC

    If in doubt, read the documentation. get_cell is applicable to worksheets, rather than parser instances. $excel is the name of your parser (Spreadsheet::ParseExcel) instance.

    Update: I think you need to sit down and step through your code, ensure it's doing what you think it should be doing.