Hello, I agree that it would be nice to use one package to read and modify an Excel Sheet. I have only had to do either one or the other, read a sheet and use the data for something else, or export data to an Excel-Sheet. Perhaps you might like to look at xlrd:
http://www.lexicon.net/sjmachin/xlrd.htm It works fines as far as reading Excel is concerned. Greetings, Richard Sharp Gregory Piñero wrote: > No, by it I meant pyExcelerator :-) > > On 7/11/06, Larry Bates <[EMAIL PROTECTED]> wrote: > > If by "it" you mean Excel's COM interface, it most certainly will. > > With COM you call all the same functions/methods that Microsoft > > calls to open, save, and manipulate the spreadsheet. > > > > Here are a few links that might help: > > > > http://mathieu.fenniak.net/plotting-in-excel-through-pythoncom/ > > http://www.markcarter.me.uk/computing/python/excel.html > > http://mathieu.fenniak.net/plotting-in-excel-through-pythoncom/ > > > > Hope info helps. > > > > -Larry > > > > Gregory Piñero wrote: > > > I'm pretty sure it doesn't support reading an existing document. That > > > would be useful. > > > > > > On 7/11/06, Larry Bates <[EMAIL PROTECTED]> wrote: > > >> Marco Aschwanden wrote: > > >> > > > >> > Hi > > >> > > > >> > I would like to > > >> > 1. import an existing Excel-sheet (a template) > > >> > 2. and add some data to it > > >> > 3. and save it under a different name afterwards. > > >> > > > >> > To me it seems, that pyExcelerator does not support the reading for > > >> > modification of an Excel-sheet. It allows only the "parse_xls" but I > > >> > would like to keep the "formatting" in the template. > > >> > > > >> > Did I miss a "load", "read" or "open" function in pyExcelerator that > > >> > would hand me back a WorkBook? > > >> > > > >> > Greetings, > > >> > Marco > > >> > > > >> > > > >> If you are on Windows, you may find using COM interface to > > >> actual Excel application easier. > > >> > > >> -Larry Bates > > >> -- > > >> http://mail.python.org/mailman/listinfo/python-list > > >> > > > > > > > > > > > > > -- > Gregory Piñero > Chief Innovation Officer > Blended Technologies > (www.blendedtechnologies.com) -- http://mail.python.org/mailman/listinfo/python-list
