pyExcelerator - Can I read and modify an existing Excel-WorkBook?
sbrown at skyesystems.com
Thu Jan 31 18:37:52 CET 2008
Yes indeed, pyExcelerator does support reading data from excel
spreadsheets. An example of how to do this is included in the file
xls2csv-gerry.py under the directory ... pyExcelerator/examples/tools
Syntax is pretty straight forward. extract_all = parse_xls(filename, CP
= None) where CP is the encoding format used within tht file. Uses
same codes that xlrd uses, ie 'cp437' = US English.
All you need is the "parse_xls" command and simply let it iterate
through your spreadsheet file.
fname = "D:\\Directory\\myfile.xls" # an example filename
for sheet_name, values in parse_xls(fname ): # parse_xls(arg) --
print " name of sheet is = ", sheet_name,
Alternatively you can extract everything in one go...
extract_all = parse_xls(fname)
More information about the Python-list