| Refresh | Home EGTry.com

write data into excel style csv file


package egtry.test;


import java.io.StringWriter;
import org.apache.commons.csv.CSVPrinter;
import org.apache.commons.csv.CSVStrategy;

public class ExcelCSVWriter {

	public static void main(String[] args) throws Exception {
		StringWriter out=new StringWriter();
		CSVPrinter writer=new CSVPrinter(out, CSVStrategy.EXCEL_STRATEGY);
		String[] row={"Number \"1\"", "8/15/2011", "line1\nline2\nline3"};
		writer.println(row);
		System.out.println(out);
	}
}


output

"Number ""1""",8/15/2011,"line1
line2
line3"