csv to excel format problem

MM marco.mechi at gmail.com
Tue Oct 14 18:49:15 CEST 2008


On 14 Ott, 12:03, MM <marco.me... at gmail.com> 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):
>   style = XFStyle()
>   style.num_format_str = '0.00E+00'
>   cno = 0
>   for column in columns:
>     worksheet.write(lno, cno, column,style)
>     cno = cno + 1
>
> nrow = 0
> csvfile = file('res1.txt','r')
> csvreader = csv.reader(csvfile, delimiter='\t')
>
> for line in csvreader:
>     writeExcelRow(worksheet,nrow,line)
>     nrow += 1
>
> csvfile.close()
> w.save('numbers.xls')
>
> All goes well and the resulting file "numbers.xls" has all the numbers
> in the right place....
>
> The problem is that excel sees the numbers as text and gives the error
> "numbers stored as text" that I have to correct manually.
>
> The file res1.txt has the structure of a tab separated values of
> floating point numbers.
>
> Thank you for the help.
>
> Marco

I've found the answer by myself...
Maybe for you it would be simple!


for line in csvreader:
    writeExcelRow(worksheet,nrow,map(float,line))
    nrow += 1


Thank you anyway



More information about the Python-list mailing list