norseman at hughes.net
Thu Jul 24 03:40:53 CEST 2008
I'm only talking about IPC related.
I have googled, yahooed, and so forth for several months now. ALL
examples I've come across have failed including those pertinent in the
Python doc area.
ls -1 *.xls >thislist #ls hyphen one
(yes - ls can go here if wanted. easier to edit outside)
loop until done
start excel (or scalc)
have it open file
have it save file as a .csv (or .dbf)
close excell (or scalc)
Would seem to be a trivial exercise.
Starting Excel or any other executable in system path works fine.
popen3 opens whatever and reports no errors. r,w,and e all check as
r,w,e= os.popen3('ls -l')
print r.read() # works as expected
ALL attempts to send instructions to Excel or scalc FAIL COMPLETELY.
Actually, any attempt to communicate with a 'Point'n'Click' program
fails without errors being cited. They don't use redirectable command
line interfaces (like piping between programs) do they? :)
Trying to use the examples I have found that supposedly setup IPC's of
one type or another have all failed with errors that point to things
that make no sense in the first place.
Before you post a code example or a link to one be kind enough to run it
yourself first. You may get a surprise. The OOo examples do not work.
Not even when switching my system to their version. One problem they
have is asking a general user to change to places the user has no place
being and then to work there without permissions. I guess somebody
insists on doing all their work with root clearance down in the middle
of the vendor's tree. I don't think that's a healthy way to do things,
In OOo in particular, using their version of VBA one can create the
macro and even port it to python. If one found the correct Microsoft
suite docs I suspect that same could be done there too. But that doesn't
activate it from a python control. As for setting the macro to run at
startup, well... maybe I had other uses in mind today???? Besides the
moment I change it, coworker in other room is going to decide to... :)
Let's stick to Microsoft Office and OpenSource products for now. My
final goal will require specific conversations with a commercial vendor.
I would like those spread sheets working though.
norseman at hughes.net
More information about the Python-list