[Tutor] Extracting information from an EXCEL/Matlab file to use in Python

[wesley chun]

On Wed, Feb 11, 2009 at 12:16 PM, "Shantanoo Mahajan (शंतनू महाजन)"
<shantanoo at gmail.com> wrote:
> On 12-Feb-09, at 1:31 AM, Andres Sanchez wrote:
>
>> I am trying to extract information from a spreadsheet to use it in Python.
>
> For reading .xls: http://pypi.python.org/pypi/xlrd/0.5.2
> For writing .xls: http://sourceforge.net/projects/pyxlwriter/


pyXLWriter -- http://pypi.python.org/pypi/pyXLWriter

...stopped active development back in Aug 2004. it was "replaced" by...

pyExcelerator -- http://pypi.python.org/pypi/pyExcelerator

...which has also stopped development (last release was Aug 2005). now
ppl use...

 xlwt -- http://pypi.python.org/pypi/xlwt

... which appears to be actively maintained and developed.

xlrd and xlrt do not require a win32 box, i.e., you can use *ix/MacOS
to read/write .xls files. if you are an active win32 developer, you
may wish to consider Python's Extensions for Windows to
control/manipulate Excel directly -- http://pywin32.sf.net -- FWIW,
there is some info on how to do this in Chapter 23 of "Core Python
Programming".

hope this helps!
-wesley
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"Core Python Programming", Prentice Hall, (c)2007,2001
"Python Fundamentals", Prentice Hall, (c)2009
    http://corepython.com

wesley.j.chun :: wescpy-at-gmail.com
python training and technical consulting
cyberweb.consulting : silicon valley, ca
http://cyberwebconsulting.com