opening excel

[timmy]

Hello,

has anybody got any experience opening and manilpulating excel
spreedsheets via python? it seems pythoncom allows this to happen but
i'm a total newb to it. (i usually work in the unix world)
all i need to do, is open the xls files and read values from it.

 

[John Machin]

Hello,

has anybody got any experience opening and manilpulating excel
spreedsheets via python? it seems pythoncom allows this to happen but
i'm a total newb to it. (i usually work in the unix world)
all i need to do, is open the xls files and read values from it.

If you really mean "read" rather than "manipulate", have a look at the
xlrd package (of which I'm the author).

http://www.python.org/pypi/xlrd

BTW, it's pure Python; you can run it on your unix box if you like

Cheers,
John

 

[timmy]

If you really mean "read" rather than "manipulate", have a look at the
xlrd package (of which I'm the author).

http://www.python.org/pypi/xlrd

BTW, it's pure Python; you can run it on your unix box if you like

Cheers,
John

sweet thats what i'd like to do

 

[Chris Cioffi]

You can also check out the pyExcelerator project.

http://sourceforge.net/projects/pyexcelerator

It seems to work reasonably well at direct Excel file manipulation.
However it isn't meant as a VBA replacement kind of thing.

Chris