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 _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
