Connecting Tech Pros Worldwide Help | Site Map

update an excel with spreadsheet

Newbie
 
Join Date: Apr 2009
Posts: 13
#1: May 6 '09
Can we edit a worksheet of excel through spreadsheet::writeExcel.
Because when I am using
my $workbook = Spreadsheet::WriteExcel->new('D:\test_result.xls');

this statement is creating the excel file again. I want to update an excel sheet means if the some data already exist, the new data should be append to it...

Thanks in Advance
-Lav
gpraghuram's Avatar
Expert
 
Join Date: Mar 2007
Location: Chennai
Posts: 1,256
#2: May 7 '09

re: update an excel with spreadsheet


Hi,
read the description given in this page.


Raghu
nithinpes's Avatar
Expert
 
Join Date: Dec 2007
Posts: 400
#3: May 7 '09

re: update an excel with spreadsheet


You may have to make use of Spreadsheet::ParseExcel::SaveParser
Reply