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]

Re: opening excel


timmy wrote:

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]

Re: opening excel

John Machin wrote:

timmy wrote:
>

>>Hello,
>>
>>has anybody got any experience opening and manilpulating excel
>>spreedsheet s 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
>

sweet thats what i'd like to do

[Chris Cioffi]

Re: opening excel

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

On 11/9/06, at open-networks.net"@b ag.python.org timmy <"timothywrot e:

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.
--

http://mail.python.org/mailman/listinfo/python-list

>

--
"A little government and a little luck are necessary in life, but only
a fool trusts either of them." -- P. J. O'Rourke