Duane Bronson wrote > Perhaps you can call unlink() before saving the file.
ooh, crashed and burned. it made pretty colors though, like a ship burning up on atmo-reentry. whee! Greg ________________________________ From: [EMAIL PROTECTED] on behalf of Greg London Sent: Mon 10/2/2006 6:56 PM To: Andy Lester Cc: Boston Perl Mongers Subject: Re: [Boston.pm] OLE, excel, and perl Andy Lester wrote: >I've never used any of the OLE stuff. I've always used >Spreadsheet::WriteExcel and ::ReadExcel. I believe this came up months ago when I was writing the script in the first place. I need to be able to open a spreadsheet that has values already in it, change -some- of those values, let the spreadsheet recalculate, and then read some result values. I believe I was informed that OLE was the only way to do this. Or maybe I was drunk. Duane Bronson wrote > Perhaps you can call unlink() before saving the file. open file unlink file modify file save file close file? That's so crazy, it just might work. > Or copy the file locally, modify the local copy, > and then copy it back to the shared drive. Hm, the script is running on four different Windows operating systems, in at least two different countries, but I think I can safely assume C:\TEMP exists. That might be the "I don't ahve to think, it'll just work" solution. > Is the case correct? my $Book = $Excel->Workbooks->Open($dest_xls); my $sheet = $Book->Worksheets(1); #... $Book->Save; $Book->Close; The filename only occurs once, during the Open. All the otehr operations are object oriented. If the name were the wrong case, would it open without complaint but complain on save? > Does it work if the file is vopu.xls? Or VOPU.XLS ? I can try locally, but I dont' think that's a solution teh project can handle. I'm not the only thing using this file or filename. and there's lot of inertia behind it at this point. >$filename=~ s/(\d*)[.]/++$1.'.'/e; I have no idea what that will do. Ok, time to try some of this stuff. (Yoda) there is no try Shut green dude. Greg _______________________________________________ Boston-pm mailing list [email protected] http://mail.pm.org/mailman/listinfo/boston-pm _______________________________________________ Boston-pm mailing list [email protected] http://mail.pm.org/mailman/listinfo/boston-pm
