-----Original Message-----
From: Kelvin Philip [mailto:[email protected]]
Sent: Wednesday, May 27, 2009 2:45 PM
To: [email protected]
Subject: How to append to existing excel sheet?
>>Hi,
>>Is there any method to append a row to an existing Excel file? Can I do it
>>using the Spreadsheet::WriteExcel module?
>>Looking forward to hear from you.
>>Regards,
>>Kelvin
Hi Kevin
Use 'write' method. Refer CPAN description of Spreadsheet::WriteExcel
Change the column no. using for loop & keep the row no. fixed.
e.g. for appending into 3rd row upto 100th column
$row = 3;
for $col (1..100)
{
$worksheet->write($row, $col, $data);
}
#$data will be specific for each cell
Regards,
Sanket Vaidya
_____________________________________________________________________
This e-mail message may contain proprietary, confidential or legally privileged
information for the sole use of the person or entity to whom this message was
originally addressed. Any review, e-transmission dissemination or other use of
or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you have received
this e-mail in error kindly delete this e-mail from your records. If it appears
that this mail has been forwarded to you without proper authority, please
notify us immediately at [email protected] and delete this mail.
_____________________________________________________________________
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
http://learn.perl.org/
