I'm stumped. I have a script that opens a spreadsheet,
modifies some values, and saves the new version.
The code looks like this:
(PASTE)
# open Excel file
my $Book = $Excel-Workbooks-Open($dest_xls);
my $sheet = $Book-Worksheets(1);
On Oct 2, 2006, at 3:58 PM, Greg London wrote:
# open Excel file
my $Book = $Excel-Workbooks-Open($dest_xls);
my $sheet = $Book-Worksheets(1);
I've never used any of the OLE stuff. I've always used
Spreadsheet::WriteExcel and ::ReadExcel.
--
Andy Lester = [EMAIL PROTECTED] =
In case that gibberish isn't readble,
I'm running perl from Windows,
ActiveState perl version 5.8.8.
and I'm opening/modifying/saving
a spreadsheet on a windows
letter drive that is mapped to a
unix drive.
From: [EMAIL PROTECTED] on behalf of Greg London
Sent:
Perhaps you can call unlink() before saving the file. Or copy the file
locally, modify the local copy, and then copy it back to the shared drive.
Or, you can use Win32::GuiTest and FindWindowLike(Confirm File Delete)
and SetForegroundWindow() and SendKeys(y). Hahaha - nerd humor.
As for the
A file named VOPU.xls already exists in this location.
Do you want to replace it?
Yes/No/Cancel.
As for the why part, I couldn't say.
SAMBA is straddling a cultural divide. Oddities like this are to be
expected.
When it's open from the Unix drive, Excel apparently can't tell that
it's
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
On Oct 2, 2006, at 5:56 PM, Greg London wrote:
I believe I was informed that OLE was the
only way to do this. Or maybe I was drunk.
Definitely not true. In fact, Spreadsheet::{Read,Write}Excel run
just fine on Linux.
--
Andy Lester = [EMAIL PROTECTED] = www.petdance.com = AIM:petdance
Andy Lester [mailto:[EMAIL PROTECTED] wrote:
On Oct 2, 2006, at 5:56 PM, Greg London wrote:
I believe I was informed that OLE was the
only way to do this. Or maybe I was drunk.
Definitely not true. In fact, Spreadsheet::{Read,Write}Excel run
just fine on Linux.
Hm, does it also run on
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
is there a $Book-Save(-force=true) kind of option?
maybe it's just confused as to whether it can overwrite
teh existing file.
Gonna be a long night.
From: Greg London
Sent: Mon 10/2/2006 5:04 PM
To: Greg London; Boston Perl Mongers
Subject: RE:
On 2 Oct 2006, [EMAIL PROTECTED] wrote:
On Oct 2, 2006, at 5:56 PM, Greg London wrote:
I believe I was informed that OLE was the
only way to do this. Or maybe I was drunk.
Definitely not true. In fact, Spreadsheet::{Read,Write}Excel run
just fine on Linux.
While this is true, they are
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
12 matches
Mail list logo