PERL Miscellaneous - problems writing existing worksheet

Author

problems writing existing worksheet

C.Nieboer@gmail.com

2005-06-03, 9:07 am

Hello,

I'm verry new with Perl....blahblah

I have a perl script who read out a txt file and extract some
information from it. The output of it is placed in a new Excel file
create with:

my $workbook = Spreadsheet::WriteExcel->new($file);
my $worksheet = $workbook->addworksheet();
my $format = $workbook->add_format();

But what i want is that the output comes in an existing workbook and
overwrite a specific (existing) worksheet.

The perl script is called from a VBA macro so the xls file where to
write the output is allready open.

I've looked on several sites and tried several things, but i cant get
it work. I have tried OLE Spreadsheet:SimpleExcel&WriteExcel.

Can someone tell me which module i have to use... and maybe good
tutorial url for this problem.

Allready Thanks CN

A. Sinan Unur

2005-06-03, 3:58 pm

C.Nieboer@gmail.com wrote in news:1117793625.036970.137720
@g43g2000cwa.googlegroups.com:

> I'm verry new with Perl....blahblah

As you have noticed, pointing out your experience level is completely
unnecessary, so please don't do it.

Please read the posting guidelines for this group to learn how to help
yourself and help others help you.

> I have a perl script who read out a txt file and extract some
> information from it. The output of it is placed in a new Excel file
> create with:
>
> my $workbook = Spreadsheet::WriteExcel->new($file);
> my $worksheet = $workbook->addworksheet();
> my $format = $workbook->add_format();
>
> But what i want is that the output comes in an existing workbook and
> overwrite a specific (existing) worksheet.
>
> The perl script is called from a VBA macro so the xls file where to
> write the output is allready open.

Given that you are already using VBA etc, you should probably be looking
into using Win32::OLE and manipulating the worksheet through Excel's OLE
interface.

I do not think you can write to a file that is open for full access by
Excel.

Sinan

--
A. Sinan Unur <1usa@llenroc.ude.invalid>
(reverse each component and remove .invalid for email address)

comp.lang.perl.misc guidelines on the WWW:
http://mail.augustmail.com/~tadmc/c...guidelines.html

C.Nieboer@gmail.com

2005-06-07, 8:57 am

Sinan,

Thanks for your reply.
I've tried the past w

end several things, because i hoped there was a
way to write to an open excel file. But i think i have to look for a
cut and paste option, or something like that.

Thanks for your help CN

A. Sinan Unur schreef:
> C.Nieboer@gmail.com wrote in news:1117793625.036970.137720
> @g43g2000cwa.googlegroups.com:
>
>
> As you have noticed, pointing out your experience level is completely
> unnecessary, so please don't do it.
>
> Please read the posting guidelines for this group to learn how to help
> yourself and help others help you.
>
>
> Given that you are already using VBA etc, you should probably be looking
> into using Win32::OLE and manipulating the worksheet through Excel's OLE
> interface.
>
> I do not think you can write to a file that is open for full access by
> Excel.
>
> Sinan
>
> --
> A. Sinan Unur <1usa@llenroc.ude.invalid>
> (reverse each component and remove .invalid for email address)
>
> comp.lang.perl.misc guidelines on the WWW:
> http://mail.augustmail.com/~tadmc/c...guidelines.html

Sponsored Links