Thanks a lot Todd, I am working on this, if I get any doubt will get back to you. Meanwhile if you or someone have more information about the same, the it will be a great help.
-- Regards, Mustafa -----Original Message----- From: Todd Beverly [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2008 10:09 PM To: Mohammed Mustafa (WT01 - PES - Semi (Technology)) Cc: perl-win32-users@listserv.ActiveState.com Subject: Re: Perl and XLS operation 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/Spread sheet/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 Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
