This worked for me... I found it in a book (so I'm not sure what happens
and exactly why) while looking how to read from Excel workbooks. (First
thing I need to do is upgrade my version of Perl, then I'll try the module
you refer to below.
Anyway, give this a try:::
use Win32;
use OLE;
$exceldoc = CreateObject OLE 'Excel.Application' || die $!;
$exceldoc->{Visible} = 1;
$workbook = $exceldoc->Workbooks->Open('c:\folder\filename.xls');
$workbook = $exceldoc->Workbooks->Add();
$worksheet = $workbook->Worksheets(1);
$worksheet -> Cells(2,1)->{'Value'} = ["Whatever you want to put in the cell"];
Of course, you can change the value of "Cells".
I'm sure there is a better way from a guru out there.
Hope this helps.
Carl
At 09:59 PM 5/16/2001 +0200, Chris Tréfois wrote:
>Hello,
>
>And here's already my first question.
>
>I have just heard about the module Spreadsheet::WriteExcel for
>ActivePerl And I immediately installed it. Everything went good until I
>figured out the following problem: I can create a new Excell workbook,
>but how can I modify it later on?? I have heard about
>Spreadsheet:ParseExcel who can print out the content of an excel file,
>but I didn't find anything on how to modify an existing excel
>workbook...
>
>Is anybody out there who as had the same problem or does anyone know how
>to solve it (perhaps in an other way??) ?
>
>Looking forward to hearing from you soon
>
>
>--
>Christophe Tréfois
