I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Posted on 2008-07-16 10:39:14-07 by runjun
unable to run Spreadsheet::ParseExcel::SaveParser
The code I used is
#!usr/bin/perl-w use strict; use Spreadsheet::ParseExcel::SaveParser; $oBook = Spreadsheet::ParseExcel::SaveParser::Workbook->Parse('Excel/Test97.xls'); my $oWs = $oBook->AddWorksheet('TEST1'); $oWs->AddCell(10, 1, 'New Cell'); $oBook->SaveAs('iftest.xls');
The error I got is 'Spreadsheet::ParseExcel::Workbook is empty' I cant trace the error.
Direct Responses: 8331 | Write a response
Posted on 2008-07-16 16:27:19-07 by jmcnamara in response to 8328
Re: unable to run Spreadsheet::ParseExcel::SaveParser

You need to load Spreadsheet::ParseExcel before Spreadsheet::ParseExcel::SaveParser due to a bug in SaveParser:

... use Spreadsheet::ParseExcel; use Spreadsheet::ParseExcel::SaveParser; ...

--
John.
Direct Responses: 8361 | Write a response
Posted on 2008-07-19 09:23:11-07 by runjun in response to 8331
Re: unable to run Spreadsheet::ParseExcel::SaveParser
thanx I was able to run the prog & also found one more bug(use of global variable) so mow the final cose is:
#!usr/bin/perl-w use strict; use Spreadsheet::ParseExcel; use Spreadsheet::ParseExcel::SaveParser; my $oBook = Spreadsheet::ParseExcel::SaveParser::Workbook->Parse('Excel/Test97.xls'); my $oWs = $oBook->AddWorksheet('TEST1'); $oWs->AddCell(10, 1, 'New Cell'); $oBook->SaveAs('iftest.xls');
Direct Responses: Write a response