Java实现CSV文件读写操作

最新推荐文章于 2024-07-22 20:46:18 发布

杨鑫newlfe

最新推荐文章于 2024-07-22 20:46:18 发布

阅读量820

点赞数

分类专栏： Java 文章标签： Java CSV 读写文件

本文链接：https://blog.csdn.net/u012965373/article/details/83750580

版权

Java 专栏收录该内容

427 篇文章 33 订阅

订阅专栏



import com.xxx.conf.Constant;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.stereotype.Component;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.util.ArrayList;
import java.util.List;

/**
 * @author yangxin_ryan
 * CSV文件操作部分包含读取CSV，写入CSV
 */
@Component
public class CSVUtil {

    private Log LOG = LogFactory.getLog(CSVUtil.class);

    /**
     * 导出
     * @param file csv文件(路径+文件名)，csv文件不存在会自动创建
     * @param dataList 数据
     * @return
     */
    public boolean exportCsv(File file, List<String> dataList){
        boolean isSucess = false;
        FileOutputStream fileOutputStream = null;
        OutputStreamWriter outputStreamWriter = null;
        BufferedWriter bw = null;
        try {
            fileOutputStream = new FileOutputStream(file);
            outputStreamWriter = new OutputStreamWriter(fileOutputStream, Constant.dataEncode_UTF_8);
            bw = new BufferedWriter(outputStreamWriter);
            if(dataList != null && !dataList.isEmpty()){
                for(String data : dataList){
                    bw.append(data).append("\r");
                }
            }
            isSucess = true;
        } catch (Exception e) {
            isSucess = false;
        }finally{
            if(bw != null){
                try {
                    bw.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
            if(outputStreamWriter != null){
                try {
                    outputStreamWriter.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
            if(fileOutputStream != null){
                try {
                    fileOutputStream.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        return isSucess;
    }

    /**
     * 导入
     * @param file csv文件(路径+文件)
     * @return
     */
    public List<String> importCsv(File file){
        List<String> dataList = new ArrayList<>();
        BufferedReader br = null;
        try {
            br = new BufferedReader(new FileReader(file));
            String line = "";
            while ((line = br.readLine()) != null) {
                dataList.add(line);
            }
        }catch (Exception e) {
            e.printStackTrace();
        }finally{
            if(br != null){
                try {
                    br.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        return dataList;
    }
}