expoprt date to csv file

[papele]

Hi all, I've a problem with a simple java code. I've to export String in csv file. I've done this right but I could not move the text into columns, only rows.
How can I move the text into columns?

This is my code:

import java.io.FileWriter;
import java.io.IOException;
 
public class GenerateCsv
{
   public static void main(String [] args)
   {
	   generateCsvFile("test.csv"); 
   }
 
   private static void generateCsvFile(String sFileName)
	{
		try
		{
		    
		    FileWriter writer = new FileWriter(sFileName);
		    
			writer.append("DisplayName");
			writer.append(',');
			writer.append("Age");
			writer.append('\n');
			
 
			writer.append("MKYONG");
			writer.append(',');
			writer.append("26");
			writer.append('\n');
			
			writer.append("YOUR NAME");
			writer.append(',');
			writer.append("29");
			writer.append('\n');
 
			//generate whatever data you want
 
			writer.flush();
			writer.close();
		}
		catch(IOException e)
		{
		 e.printStackTrace();
		} 
	}
}

For example,

 writer.append('\n');

down one line but I want to move in the next column right (of csv file), not down line.

Thank you all

[dlorde]

In CSV files, the 'columns' are separated by commas (,) - hence the name Comma Separated Value (CSV).

[papele]

Hi dlorde,
I know that In CSV files, the 'columns' are separated by commas (,) but, as you can see from my code, I use

 writer.append(',');

but it dosen't work correctly.

I don't understand if you meant this.

Could you write the instruction to move in the right column?

Thank you

[Tolls]

So, what output do you get?
Because that looks correct to me.

[papele]

This is my output on csv file now:


This is the output I want:



Thank you

[Tolls]

No it isn't.
That's your output as viewed through whatever spreadhseet program you're using.
What does the csv file look like in a text editor, because to me it looks like the csv is fine, but your spreadsheet program isn't.

In any case, the output you want is not what would normally be thought of as the layout for a csv as seen through a spreadsheet.