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

2005-01-11 Thread Peter Otten 
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()

-- 
http://mail.python.org/mailman/listinfo/python-list

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

2005-01-11 Thread Kent Johnson 
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()

--
http://mail.python.org/mailman/listinfo/python-list

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

2005-01-11 Thread simon.alexandre 
ok thanks
it works

S.


Kent Johnson [EMAIL PROTECTED] a écrit dans le message de
news:[EMAIL PROTECTED]
 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()
 
 


-- 
http://mail.python.org/mailman/listinfo/python-list