Hello.
[EMAIL PROTECTED] wrote:
> Hi All,
>
>
> I want to writting a perl script which let me override/edit the
> existing or created XLS. But I am unable to do that. I am not
> sure, do I have to use few more CPAN module or what .
>
<snip>
>
>
> Here, at first time I am able to open a XLS and write to that, but
> if I want to do some changes next time, then it is not allowing me
> to do that.
> and getting the follwing error.
>
> C:\Documents and Settings\x0069183\Desktop\Mustafa>perl hello.pl
> *Can't open perl.xls. It may be in use or protected at hello.pl
> line 13
> (in cleanup) Can't use string ("") as a symbol ref while
> "strict refs" in use at
> C:/Perl/site/lib/Spreadsheet/WriteExcel/Workbook.pm line 295.
> Can't call method "add_worksheet" on an undefined value at
> hello.pl line 16.*
>
> Here I have used the module spreadsheat::WriteExcel.
>
>
According to the WriteExcel docs:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.25/lib/Spreadsheet/WriteExcel.pm#MODIFYING_AND_REWRITING_EXCEL_FILES
you need to use the Spreadsheet::ParseExcel module is you want to read
and rewrite your XLS file
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
