Re: extra rows in a CSV module output when viewed in excel 2007

2010-08-19 Thread JonathanB
On Aug 20, 9:10 am, MRAB wrote: > JonathanB wrote: > > On Aug 13, 3:52 pm, alex23 wrote: > >> On Aug 13, 4:22 pm, JonathanB wrote: > > >>>         writer = csv.writer(open(output, 'w'), dialect='excel') > >> I think - not able to test atm - that if you open the file in 'wb' > >> mode instead it

Re: extra rows in a CSV module output when viewed in excel 2007

2010-08-19 Thread MRAB
JonathanB wrote: On Aug 13, 3:52 pm, alex23 wrote: On Aug 13, 4:22 pm, JonathanB wrote: writer = csv.writer(open(output, 'w'), dialect='excel') I think - not able to test atm - that if you open the file in 'wb' mode instead it should be fine. changed that to writer = csv.writer(op

Re: extra rows in a CSV module output when viewed in excel 2007

2010-08-19 Thread JonathanB
On Aug 13, 3:52 pm, alex23 wrote: > On Aug 13, 4:22 pm, JonathanB wrote: > > >         writer = csv.writer(open(output, 'w'), dialect='excel') > > I think - not able to test atm - that if you open the file in 'wb' > mode instead it should be fine. changed that to writer = csv.writer(open(output,

Re: extra rows in a CSV module output when viewed in excel 2007

2010-08-12 Thread alex23
On Aug 13, 4:22 pm, JonathanB wrote: >         writer = csv.writer(open(output, 'w'), dialect='excel') I think - not able to test atm - that if you open the file in 'wb' mode instead it should be fine. -- http://mail.python.org/mailman/listinfo/python-list

extra rows in a CSV module output when viewed in excel 2007

2010-08-12 Thread JonathanB
The subject basically says it all, here's the code that's producing the csv file: def write2CSV(self,output): writer = csv.writer(open(output, 'w'), dialect='excel') writer.writerow(['Name','Description','Due Date','Subject', 'Grade','Maximum Grade', se