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

Re: csv to excel format problem

2008-10-14 Thread John Machin
On Oct 15, 3:49 am, MM <[EMAIL PROTECTED]> wrote: > On 14 Ott, 12:03, MM <[EMAIL PROTECTED]> wrote: > > I'm trying to import a tab separated values file onto Excel with the > > following script: > > > import csv > > from pyExcelerator import * Consider using xlwt instead ... see http://pypi.pytho

Re: csv to excel format problem

2008-10-14 Thread MM
On 14 Ott, 12:03, MM <[EMAIL PROTECTED]> wrote: > 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):

[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