On Wednesday, June 12, 2002, at 12:00 , Rob wrote:
> Does anyone have any advice on how to write to an EXISTING MS Excel file?
> The goal is to have a script update values in an excel file.
I would of course start at the CPAN and look at
http://search.cpan.org/search?dist=Spreadsheet-WriteExcel
and
http://search.cpan.org/search?dist=Spreadsheet-ParseExcel
and/or
http://search.cpan.org/search?mode=module&query=Excel
They have some demo code there that should help you work with
some ways to deal with the basic issue here.
Your 'worst case' option would be
a) make a temp backup of the file
b) read in the original file
c) update the data set
d) write down the new file
e) verify that all is kosher,
if($kosher) {
unlink($tmpFile);
}else{
moveBack($tmpFile, $origFile);
signalCoderNFO($AnnoyingWhine);
}
ciao
drieux
---
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
