java 生成 csv文件_JAVA 自动生成本地CSV文件

/**

* CSV文件生成方法

* @param head 文件头

* @param dataList 数据列表

* @param outPutPath 文件输出路径

* @param filename 文件名

* @return

*/

public static File createCSVFile(List head, List> dataList,String outPutPath, String filename) {

File csvFile = null;

BufferedWriter csvWtriter = null;

try {

csvFile = new File(outPutPath + File.separator + filename + ".csv");

File parent = csvFile.getParentFile();

if (parent != null && !parent.exists()) {

parent.mkdirs();

}

csvFile.createNewFile();

// GB2312使正确读取分隔符","

csvWtriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(

csvFile), "GB2312"), 1024);

// 写入文件头部

writeRow(head, csvWtriter);

// 写入文件内容

for (List row : dataList) {

writeRow(row, csvWtriter);

}

csvWtriter.flush();

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

csvWtriter.close();

} catch (IOException e) {

e.printStackTrace();

}

}

return csvFile;

}

/**

* 写一行数据方法

* @param row

* @param csvWriter

* @throws IOException

*/

private static void writeRow(List row, BufferedWriter csvWriter) throws IOException {

// 写入文件头部

for (Object data : row) {

StringBuffer sb = new StringBuffer();

String rowStr = sb.append("\"").append(data).append("\",").toString();

csvWriter.write(rowStr);

}

csvWriter.newLine();

}

@SuppressWarnings("static-access")

public static void main(String[] args) {

List exportData = new ArrayList();

exportData.add("第一列");

exportData.add("第二列");

exportData.add("第三列");

List> datalist = new ArrayList>();

List data=new ArrayList();

data.add("111");

data.add("222");

data.add("333");

List data1=new ArrayList();

data1.add("444");

data1.add("555");

data1.add("666");

datalist.add(data);

datalist.add(data1);

String path = "d:/exportCsv/";

String fileName = "文件导出";

File file = new CompanyHourDataController().createCSVFile(exportData, datalist, path, fileName);

String fileName2 = file.getName();

System.out.println("文件名称：" + fileName2);

}