On Sat, 30 Aug 2008 17:18:19 -0700 (PDT), John Machin <[EMAIL PROTECTED]> wrote:
Hello John (and everyone else), thanks for answering. >It helps in situations like this to mention details of your >environment >(1) what version of what operating system (Linux, OS X, Windows, etc) >(2) what version of Python >as the available solutions are often dependent on the answers. Yes, of course. I sometimes forget the most essential of things. - winxp, sp2 - python 2.5.2 > >For Python version 2.[345] on any platform, you can use xlwt, which is >as simple as this for writing a 1-worksheet Excel 97-to-2003 XLS file >(without any formatting): Actually, that might work. What I was needing (aiming for) was a way to write to excel 2003 files. Formatting is not necessary, since what I'm trying to write is some tabular data; results from fortran-python simulation (I can explain, but the details seem irrelevant for this case). I'm trying to avoid the text file - import to excel - mechanism, since there is quite a lot of files written. > >def write_xls(file_name, sheet_name, data): > import xlwt > book = xlwt.Workbook() > sheet = book.add_sheet(sheet_name) > rowx = 0 > for row in data: > rowx += 1 > for colx, value in enumerate(row): > sheet.write(rowx, colx, value) > book.save(file_name) ># data can be any of the following Python types: int, long, float, >decimal.Decimal, datetime.date, datetime.datetime, bool, str, and >unicode. > >xlwt is available from https://secure.simplistix.co.uk/svn/xlwt/trunk > >I suggest that you join the python-excel group (http:// >groups.google.com.au/group/python-excel?hl=en) or at least read some >of the questions and responses. Please, one more question. As you have noticed, I posted my message to comp.lang.python, using a newsreader. Is there a way to access google groups through a similiar interface program as a newsreader. Never used them before, and getting a lot of messages to my email every day does not sound very appealing to me. Best regards Marin > >HTH, > >John -- http://mail.python.org/mailman/listinfo/python-list
