java+csv+write_java写csv文件

最新推荐文章于 2024-05-29 08:28:42 发布

原创最新推荐文章于 2024-05-29 08:28:42 发布 · 649 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java+csv+write

本文介绍了一个简单的Java程序，用于将指定的数据集转换为CSV文件格式。该程序支持自定义输出路径及文件名，并能处理包含多列数据的复杂数据结构。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.OutputStreamWriter;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.LinkedHashMap;

import java.util.List;

import java.util.Map;

public class CSVUtil {

public static void main(String[] args) {

List> exportData = new ArrayList>();

Map row = null;

LinkedHashMap map = new LinkedHashMap();

map.put("1", "第一列");

map.put("2", "第二列");

map.put("3", "第三列");

map.put("4", "第四列");

for (int i = 0; i < 100; i++) {

row = new LinkedHashMap();

row.put("1", "11" + i);

row.put("2", "12" + i);

row.put("3", "13" + i);

row.put("4", "14" + i);

exportData.add(row);

}

CSVUtil.createCSVFile(exportData, map, "d:/123/", "12");

}

/**

* @param exportData 需要导出的数据

* @param rowMapper 行名称

* @param outPutPath 导出的路径

* @param filename 文件名

* @return csv文件

public static File createCSVFile(List exportData, LinkedHashMap rowMapper,

String outPutPath, String filename) {

File csvFile = null;

BufferedWriter csvFileOutputStream = null;

try {

//创建文件

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

// csvFile.getParentFile().mkdir();

File parent = csvFile.getParentFile();

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

parent.mkdirs();

}

csvFile.createNewFile();

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

csvFileOutputStream = new BufferedWriter(new OutputStreamWriter(

new FileOutputStream(csvFile), "GB2312"), 1024);

// 写入文件头部

for (Iterator propertyIterator = rowMapper.entrySet().iterator(); propertyIterator.hasNext();) {

java.util.Map.Entry propertyEntry = (java.util.Map.Entry) propertyIterator

.next();

csvFileOutputStream.write("\""

+ propertyEntry.getValue().toString() + "\"");

if (propertyIterator.hasNext()) {

csvFileOutputStream.write(",");

}

csvFileOutputStream.newLine();

// 写入文件内容

for (Iterator iterator = exportData.iterator(); iterator.hasNext();) {

// Object row = (Object) iterator.next();

LinkedHashMap row = (LinkedHashMap) iterator.next();

System.out.println(row);

for (Iterator propertyIterator = row.entrySet().iterator(); propertyIterator.hasNext();) {

java.util.Map.Entry propertyEntry = (java.util.Map.Entry) propertyIterator.next();

// System.out.println( BeanUtils.getProperty(row, propertyEntry.getKey().toString()));

csvFileOutputStream.write("\""

+ propertyEntry.getValue().toString() + "\"");

if (propertyIterator.hasNext()) {

csvFileOutputStream.write(",");

}

if (iterator.hasNext()) {

csvFileOutputStream.newLine();

}

csvFileOutputStream.flush();

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

csvFileOutputStream.close();

} catch (IOException e) {

e.printStackTrace();

}

return csvFile;

}