| Author |
Spreadsheet::WriteExcel
|
|
|
| Hello,
there's a module called Spreadsheet::WriteExcel. It allows me to create
a new worksheet and edit its cells:
my $workbook = Spreadsheet::WriteExcel->new('my.xls');
my $worksheet = $workbook->addworksheet();
$worksheet -> write('A2', 222);
But how can I put some values into the cells of an existing worksheet?
Thanks for any advice.
...:: fabio
| |
| Matt Garrish 2004-03-18, 6:47 pm |
|
"Fabio" <fabio@anti-spam.inet.alpha.pl> wrote in message
news:c21lac$9c2$2@nemesis.news.tpi.pl...
> Hello,
>
> there's a module called Spreadsheet::WriteExcel. It allows me to create
> a new worksheet and edit its cells:
>
> my $workbook = Spreadsheet::WriteExcel->new('my.xls');
> my $worksheet = $workbook->addworksheet();
> $worksheet -> write('A2', 222);
>
> But how can I put some values into the cells of an existing worksheet?
> Thanks for any advice.
>
Use the Win32::OLE module to access the spreadsheet through Excel (assuming
you're on a Windows machine and have Excel installed).
Matt
| |
|
| Matt Garrish wrote:
> Use the Win32::OLE module to access the spreadsheet through Excel (assuming
> you're on a Windows machine and have Excel installed).
Having Windows machine and Excel installed - that's what I wanted to
avoid. But if there's no other way to edit Excel files, I'll have to do
it that way. Thanks for your reply.
...:: fabio
| |
| Dave Cross 2004-03-18, 6:47 pm |
| On Tue, 02 Mar 2004 10:50:02 +0100, Fabio wrote:
> Hello,
>
> there's a module called Spreadsheet::WriteExcel. It allows me to create
> a new worksheet and edit its cells:
>
> my $workbook = Spreadsheet::WriteExcel->new('my.xls');
> my $worksheet = $workbook->addworksheet();
> $worksheet -> write('A2', 222);
>
> But how can I put some values into the cells of an existing worksheet?
> Thanks for any advice.
Maybe you could use Spreadsheet::ParseExcel -
http://search.cpan.org/dist/Spreadsheet-ParseExcel/
Dave...
|
|
|
|