in reply to using perl in excel

If you have some code you're working on could you post what you have so far?

If not, are you aware of the Excel spreadsheet modules from the CPAN? Have a look at Spreadsheet::ParseExcel::Simple, from the synopsis:

my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls'); foreach my $sheet ($xls->sheets) { while ($sheet->has_data) { my @data = $sheet->next_row; } }
and Spreadsheet::WriteExcel::Simple, again from the synopsis:
my $ss = Spreadsheet::WriteExcel::Simple->new; $ss->write_bold_row(\@headings); $ss->write_row(\@data); print $ss->data; # or $ss->save("filename.xls");

That should get you started anyway, once you get it working if you need more complex processing use Spreadsheet::WriteExcel and Spreadsheet::ReadExcel and post some code detailing where you are stuck.

Hope that helps.

Replies are listed 'Best First'.
Re^2: using perl in excel
by ktperl (Initiate) on Jan 17, 2005 at 00:33 UTC
    thanks a lot . Thanks for your help. I will try it out and get back at you.