Re: [NEWBIE] csv to excel format problem

2008-10-15 Thread Anders Eriksson
Hello Marco and welcome to the wonderful world of Python, Your problem is that the file is a text file so the values you are reading are text which you then write to the Excel sheet. So you need to convert the text value to a float value. Now the Big Cahonas has already been there so it's include

[NEWBIE] csv to excel format problem

2008-10-14 Thread MM
Hi to all, I'm trying to import a tab separated values file onto Excel with the following script: import csv from pyExcelerator import * w = Workbook() worksheet = w.add_sheet('sim1') def writeExcelRow(worksheet, lno, columns): style = XFStyle() style.num_format_str = '0.00E+00' cno = 0