Thread: Writing to csv
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Writing to csv

Yes - I see now - I had a "Comma" after the last piece of data - when I
remove it it works

Thanks!

"dlw" wrote:

Excel doesn't normally do that. There must be something in the 4th column
that is causing the comma after the 3rd one. Maybe right that column in the
sheet and delete it to make sure there is nothing there.

"Jeff" wrote:

Hi,

I am writing data to a csv. There are 3 columns.

I want the csv output to look like this (without a comma after the last
column data)

Column1 Column2 Column3
data,data2,data3
data,data2,data3
......

But the csv looks like
data,data2,data3,
data,data2,data3,

Thanks for your help