in reply to Open Excel File for Updating!!


The Spreadsheet::ParseExcel package also contains a module called Spreadsheet::ParseExcel::SaveParser which will let you read and rewrite an Excel workbook. It is a combination of Spreadsheet::WriteExcel and Spreadsheet::ParseExcel.

There is an example here: Re: open workbook-WriteExcel.

--
John.

Replies are listed 'Best First'.
Re^2: Open Excel File for Updating!!
by rad7 (Initiate) on Nov 26, 2004 at 06:47 UTC
    Hi , Spreadsheet::ParseExcel::SaveParser does the required work for me ;-))) Thank u all very much ;-)) But I doubt how to maintain the WorkSheet Protection mechanism :-(( -rad