java string to csv,在Java中的csv文件的列中写入字符串数组

so what i am trying to accomplish is to write an array of data down each cell of the column for as many array elements that i have. i want i too look like this in excel:

buyer | parts | price| quantity | comments

tom | blah | 546 | 5 | blah

| blah | 56 | 67 |

my file has manyyyyy more columns than this but i wanted to give a brief example. what also creates my problem is that i dont want to print the next column after it on the last row that the writer is on once its done my array data set, so i want it to be on that forst line. i have looked into other libraries for accomplishing this, but there is nothing that i can find that seems to meet my needs. i do understand the nature of CSV file may not allow this to happen, without manually adding in blank cells, but is there any other way to do this?

Enumeration paramNames = request.getParameterNames();

while(paramNames.hasMoreElements())

{

String paramName = (String)paramNames.nextElement();

writer.append(paramName);

writer.append(',');

String[] paramValues = request.getParameterValues(paramName);

if (paramValues.length == 1)

{

String paramValue = paramValues[0];

if (paramValue.length() == 0)

{

writer.append("No Value");

writer.append('\n');

}

else

{

writer.append(paramValue);

writer.append('\n');

}

}

else

{

for(int i = 0; i

{

writer.append(paramValues[i]);

writer.append(',');

}

writer.append('\n');

}

previousname = paramName;

}

writer.flush();

writer.close();

}

also to clarify where this data is coming from, a JSP table thats in the middle of the form, so i am reading in arrays of values that are in the table.

解决方案

/** The below Java Code writes

* some data to a file in CSV

* (Comma Separated Value) File

*/

package developer;

import java.io.FileWriter;

import java.io.IOException;

import java.io.PrintWriter;

public class MakeCSVFile {

public static void main(String[] args) throws IOException {

//Note the "\\" used in the path of the file

//instead of "\", this is required to read

//the path in the String format.

FileWriter fw = new FileWriter("D:\\JavaCodeFile\\WriteTest.csv");

PrintWriter pw = new PrintWriter(fw);

//Write to file for the first row

pw.print("Hello guys");

pw.print(",");

pw.print("Java Code Online is maing");

pw.print(",");

pw.println("a csv file and now a new line is going to come");

//Write to file for the second row

pw.print("Hey");

pw.print(",");

pw.print("It's a");

pw.print(",");

pw.print("New Line");

//Flush the output to the file

pw.flush();

//Close the Print Writer

pw.close();

//Close the File Writer

fw.close();

}

}

Probably instead of doing hard print do a loop of the array and print each value separated by a comma.

Something like :

Array array;

Iterator iter = array.iterator();

while (iter.hasNext())

{

object = iter.next();

pw.print(object.getBuyer());

pw.print(",");

pw.print(object.getTitle());

..

}