raj esh wrote: > Dear Gurus, > > I want to write some data into the Excel sheet. I have written code > ....can you people guide me where i am going wrong....! > > All code is working fine but data is not getting written in the result.xls > > Here is the code.. > > ============================================== > This is the Excel.pl file code > ============================================== > use ExcelEdit; > use strict; > use warnings; > my $obj=new ExcelEdit(); > my $worksheet=$obj->ExcelEdit::CreateSpreadSheet(); > $obj->ExcelEdit::WriteRecord($worksheet,2,3,"1","YYYYY","NNNNN");
Try saving the workbook object ref in your ExcelEdit object and do a workbook close here. Normally you would have the object open and in scope and it would close automatically. I think that either it's closing before you do your write or it's not properly closing at exit. > =================================================== > > ******************************************************************************** > Here is the ExcelEdit.pm code > ******************************************************************************** _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs