java解析csv文件工具类_java导出和导入csv文件工具类

package com.yy.utils; import java.io.BufferedReader; import java.io.File; import java.io.FileReader; import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.io.OutputStream; import java.util.ArrayList; import java.util.List; import java.util.Properties; import javax.servlet.http.HttpServletResponse; import jxl.common.Logger; public class CSVUtils { public static Logger logger = Logger.getLogger(CSVUtils.class); public static String TAB = "\r\n"; static{ Properties prop = System.getProperties(); String os = prop.getProperty("os.name").toLowerCase(); if(os.startsWith("win")){ TAB = "\r\n"; }else if(os.startsWith("linux") || os.startsWith("unix")){ TAB = "\n"; }else if(os.startsWith("mac")){ TAB = "\r"; } } /** * @Description: 导出csv * @param response * @param titles * @param data * @param fileName * @author: leijing * @date: 2016年7月28日 下午6:19:33 */ public static void exportCsv(HttpServletResponse response,List titles,List> data,String fileName){ StringBuffer sb = new StringBuffer(); OutputStream outputStream = null; for (int i = 0; i < titles.size(); i++) { if(i != titles.size() - 1){ sb.append(titles.get(i)).append(","); }else{ sb.append(titles.get(i)).append(TAB); } } for (int i = 0; i < data.size(); i++) { List row = data.get(i); for(int j = 0 ; j < row.size(); j++ ){ if(j != row.size() - 1){ sb.append(row.get(j)).append(","); }else{ sb.append(row.get(j)).append(TAB); } } } try { response.addHeader("Content-Disposition","attachment;fileName=" + new String(fileName.getBytes("UTF-8"),"iso8859-1"));   //response.addHeader("Content-Length", "" + sb.length());   //response.setContentType("application/csv;charset=UTF-8");  response.setContentType("multipart/form-data");//设置文件ContentType类型，这样设置，会自动判断下载文件类型 outputStream = response.getOutputStream(); outputStream.write(new   byte []{( byte ) 0xEF ,( byte ) 0xBB ,( byte ) 0xBF });//加上bom头，才不会中文乱码      outputStream.write(sb.toString().getBytes("UTF-8")); outputStream.flush(); } catch (IOException e) { logger.error("CSVUtils.exportCsv error:",e); }finally{ try { outputStream.close(); } catch (IOException e) { logger.error("CSVUtils.exportCsv close OutputStream error:",e); } } } /** * @Description: 导入csv * @param file * @return: List * @author: leijing   * @date: 2016年7月28日 下午6:20:14 */ public static List importCsv(File file){ List data = new ArrayList(); BufferedReader br = null; try { br = new BufferedReader(new FileReader(file)); String line = ""; while((line = br.readLine()) != null){ data.add(line); } } catch (Exception e) { logger.error("CSVUtils.importCsv error:",e); }finally{ try { br.close(); } catch (IOException e) { logger.error("CSVUtils.importCsv close BufferedReader error:",e); } } return data; } /** * * @Description: 导入csv * @param inputStream * @return: List * @author: leijing   * @date: 2016年7月28日 下午6:20:44 */ public static List importCsv(InputStream inputStream){ List data = new ArrayList(); BufferedReader br = null; try { br = new BufferedReader(new InputStreamReader(inputStream)); String line = ""; while((line = br.readLine()) != null){ data.add(line); } } catch (Exception e) { logger.error("CSVUtils.importCsv error:",e); }finally{ try { br.close(); inputStream.close(); } catch (IOException e) { logger.error("CSVUtils.importCsv close BufferedReader or InputStream error:",e); } } return data; } }