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

"Shantanoo Mahajan (शंत "Shantanoo Mahajan (शंत
Wed Feb 11 21:16:56 CET 2009


On 12-Feb-09, at 1:31 AM, Andres Sanchez wrote:

> Fellows,
>
> I am trying to extract information from a spreadsheet to use it in  
> Python. For instance, say I have the number 5.6 in cell A1 of Sheet1  
> in the file example.xls . Could anyone of you ladies and gentleman  
> let me know what commands I need to type in Pyhton to open the file  
> that contains the spreadsheet, localize cell A1, and finally save  
> the value in that cell, e.g. 5.6, as a variable in Python?
>
> Thank you for your help!!
>
> Andres

For reading .xls: http://pypi.python.org/pypi/xlrd/0.5.2
For writing .xls: http://sourceforge.net/projects/pyxlwriter/

regards,
shantanoo


More information about the Tutor mailing list