Re: xls files in perl

2010-11-12 Thread Parag Kalra
>From professional experience, I would recommend: Spreadsheet::ParseExcel Cheers, Parag On Thu, Nov 11, 2010 at 7:09 AM, Anush wrote: > Is there any code for reading an xls file in perl. > I found the following code from net, but it does not work. Please help > me. > > > #!/usr/bin/perl -w >

Re: xls files in perl

2010-11-12 Thread Shlomi Fish
On Friday 12 November 2010 11:00:16 Uri Guttman wrote: > > "CY" == Chaitanya Yanamadala writes: > i don't know the excell stuff but your code needs to be improved a bit. > > > CY> my $oExcel = new Spreadsheet::ParseExcel; > > don't use camelcase names. if the leading 'o' is for object, do

Re: xls files in perl

2010-11-12 Thread Uri Guttman
> "CY" == Chaitanya Yanamadala writes: i don't know the excell stuff but your code needs to be improved a bit. CY> my $oExcel = new Spreadsheet::ParseExcel; don't use camelcase names. if the leading 'o' is for object, don't do that. hungarian notation is also a bad idea. CY> die "You

Re: xls files in perl

2010-11-12 Thread Chaitanya Yanamadala
Try this my $oExcel = new Spreadsheet::ParseExcel; die "You must provide a filename to $0 to be parsed as an Excel file" unless @ARGV; $filename = $ARGV[0]; if(!-e $filename){ $log_data .= $filename." ==> The File Does not exist at that location\n"; &file_write($log_file,$log_data);

Re: xls files in perl

2010-11-12 Thread Jim Gibson
At 7:09 AM -0800 11/11/10, Anush wrote: Is there any code for reading an xls file in perl. I found the following code from net, but it does not work. Please help me. #!/usr/bin/perl -w use strict; use Spreadsheet::Read; use Data::Dumper; my $xls = ReadData ("Input/sample.xls"); print $xls->[

xls files in perl

2010-11-12 Thread Anush
Is there any code for reading an xls file in perl. I found the following code from net, but it does not work. Please help me. #!/usr/bin/perl -w use strict; use Spreadsheet::Read; use Data::Dumper; my $xls = ReadData ("Input/sample.xls"); print $xls->[1]{'A1'}; exit; -- To unsubscribe, e-ma