[csv module] duplication of end of line character in output file generated
 

Hi all,

I use csv module included in python 2.3. I use the writer and encouter the
following problem: in my output file (.csv) there is a duplication of the
end of line character, so when I open the csv file in Ms-Excel a blank line
is inserted between each data line.

OS: W2k

Someone has an idea ?

thanks in advance

the source code is the following:

-------------------------------------------------->
import csv

class CsvDumper:

def __init__(self):
self.object =
[['la','mb','mc','md'],['ma','mb','mc','md'],['ma','mb','mc','md']]
self.writer = csv.writer(file("Test.csv", "w"))

def DumpCsvFile(self):
for row in self.object:
self.writer.writerow(row)

c = CsvDumper()
c.DumpCsvFile()

Re: [csv module] duplication of end of line character in output file generated
 

simon.alexandre wrote:

> I use csv module included in python 2.3. I use the writer and encouter the
> following problem: in my output file (.csv) there is a duplication of the
> end of line character, so when I open the csv file in Ms-Excel a blank
> line is inserted between each data line.
>
> OS: W2k
>
> Someone has an idea ?
>
> thanks in advance
>
> the source code is the following:
>
> -------------------------------------------------->
> import csv
>
> class CsvDumper:
>
> def __init__(self):
> self.object =
> [['la','mb','mc','md'],['ma','mb','mc','md'],['ma','mb','mc','md']]
> self.writer = csv.writer(file("Test.csv", "w"))

Try opening the file in binary mode: file("Test.csv", "wb")


> def DumpCsvFile(self):
> for row in self.object:
> self.writer.writerow(row)
>
> c = CsvDumper()
> c.DumpCsvFile()

Re: [csv module] duplication of end of line character in output filegenerated
 

simon.alexandre wrote:
> Hi all,
>
> I use csv module included in python 2.3. I use the writer and encouter the
> following problem: in my output file (.csv) there is a duplication of the
> end of line character, so when I open the csv file in Ms-Excel a blank line
> is inserted between each data line.

From the docs for csv.writer():
writer( csvfile[, dialect='excel'[, fmtparam]])
...If csvfile is a file object, it must be opened with the 'b' flag on platforms where that
makes a difference.

Windows is a "platform where that makes a difference." So try
self.writer = csv.writer(file("Test.csv", "wb"))

Kent

>
> OS: W2k
>
> Someone has an idea ?
>
> thanks in advance
>
> the source code is the following:
>
> -------------------------------------------------->
> import csv
>
> class CsvDumper:
>
> def __init__(self):
> self.object =
> [['la','mb','mc','md'],['ma','mb','mc','md'],['ma','mb','mc','md']]
> self.writer = csv.writer(file("Test.csv", "w"))
>
> def DumpCsvFile(self):
> for row in self.object:
> self.writer.writerow(row)
>
> c = CsvDumper()
> c.DumpCsvFile()
>
>

Re: [csv module] duplication of end of line character in output file generated
 

ok thanks
it works

S.


"Kent Johnson" <kent3737@yahoo.com> a écrit dans le message de
news:41e3ceb6$1_3@newspeer2.tds.net...
> simon.alexandre wrote:
> > Hi all,
> >
> > I use csv module included in python 2.3. I use the writer and encouter
the
> > following problem: in my output file (.csv) there is a duplication of
the
> > end of line character, so when I open the csv file in Ms-Excel a blank
line
> > is inserted between each data line.
>
> From the docs for csv.writer():
> writer( csvfile[, dialect='excel'[, fmtparam]])
> ...If csvfile is a file object, it must be opened with the 'b' flag
on platforms where that
> makes a difference.
>
> Windows is a "platform where that makes a difference." So try
> self.writer = csv.writer(file("Test.csv", "wb"))
>
> Kent
>
> >
> > OS: W2k
> >
> > Someone has an idea ?
> >
> > thanks in advance
> >
> > the source code is the following:
> >
> > -------------------------------------------------->
> > import csv
> >
> > class CsvDumper:
> >
> > def __init__(self):
> > self.object =
> > [['la','mb','mc','md'],['ma','mb','mc','md'],['ma','mb','mc','md']]
> > self.writer = csv.writer(file("Test.csv", "w"))
> >
> > def DumpCsvFile(self):
> > for row in self.object:
> > self.writer.writerow(row)
> >
> > c = CsvDumper()
> > c.DumpCsvFile()
> >
> >