通过poi将csv导成excel

package com.tw.poi;import java.io.File;import java.io.FileInputStream;import java.io.FileWriter;import java.io.IOException;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.poifs.filesystem.POIFSFileSystem;import au.com.bytecode.opencsv.CSVWriter;/** * <p>通过poi将csv导成excel,所需的包: * opencsv-1.8.jar * poi-2.5.1-final-20040804.jar * poi-contrib-2.5.1-final-20040804.jar * poi-scratchpad-2.5.1-final-20040804.jar * 下载地址:http://www.apache.org/dyn/closer.cgi/jakarta/poi/ * * 此类待完善 * </p> * @author tw * */public class PoiCsvUtils {/** * <p>通过poi将csv导成excel</p> * @author tw 2009-07-16 * */public static void CSVexcel(){try{String xlsPath = "e:/workbook.xls";String csvFilePath = "e:/workbook.csv";CSVWriter writer = null;File tempFile = null;FileWriter fwriter = null; // 写数据try{tempFile = new File(csvFilePath);fwriter = new FileWriter(tempFile);writer = new CSVWriter(fwriter);}catch(IOException ioex){ioex.printStackTrace();}/*读取Excel文件时，首先生成一个POIFSFileSystem对象， * 由POIFSFileSystem对象构造一个HSSFWorkbook， * 该HSSFWorkbook对象就代表了Excel文档*/ POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(xlsPath)); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheetAt(0); HSSFRow row = null; HSSFCell cell = null; String cellStr = ""; //循环读取行与列的值,并将值写入CSV文件 for(int i=0;i<=sheet.getLastRowNum();i++){ row = sheet.getRow(i); String[] cellArray = new String[row.getLastCellNum()]; for(int j=0;j<row.getLastCellNum();j++){ cell = row.getCell((short) j);// 判断储存格的格式if (cell == null){cellStr = "";}else {switch (cell.getCellType()) {case HSSFCell.CELL_TYPE_NUMERIC://数字格式cellStr = cell.getNumericCellValue() + "";// getNumericCellValue()会回传double值，若不希望出现小数点，请自行转型为intbreak;case HSSFCell.CELL_TYPE_STRING://字符格式cellStr = cell.getStringCellValue();break;// case HSSFCell.CELL_TYPE_FORMULA:// System.out.print(cell.getNumericCellValue());// //读出公式储存格计算後的值// //若要读出公式内容，可用cell.getCellFormula()// break;default://不明的格式break;}}System.out.println("-----row-"+i+"-----cell-"+j+"---:"+cellStr);cellArray[j] = cellStr; } writer.writeNext(cellArray);// 把Excel一行记录写入CSV文件 } fwriter.flush();fwriter.close();writer.close();}catch(Exception e){e.printStackTrace();}}}