[Tutor] data from excel spreadsheet to csv and manipulate

[Kent Johnson]

sacha rook wrote:
> Hi
>  
> can anyone help with the best way to tackle this?
>  
> I have a spreadsheet ms excel, that has a name column that I want to 
> extract to csv and manipulate as follows.

If you can save the spreadsheet as csv then you can use the csv module 
for reading and writing.

To read the excel file directly you can use one of these:
http://www.lexicon.net/sjmachin/xlrd.htm
http://sourceforge.net/projects/pyexcelerator

If you are running on Windows then you can also script Excel directly 
with COM:
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/440661

Kent