poi操作Excel实例.doc

import java.io.BufferedInputStream; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Arrays; import java.util.Date; import java.util.List; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFDateUtil; 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; public class EditExcel { public static void main(String[] args) { String path = f://#usertemple.xls;// 文件路径 try { File files = new File(path); ListString[] list=getDataList(files); //读取 if(list!=nulllist.size()0){ for(String[] str:list){ for(int i=0;istr.length;i++){ System.out.print(str[i]+\t); } System.out.println(); } outExcel(list); //poi导出Excel } } catch (Exception e) { e.printStackTrace(); } } /** * 读取EXCEL * * @param firstrow * 从第几行开始读取 * @return 读取后返回数组 */ public static String[][] getData(File file, int firstrow) throws FileNotFoundException, IOException { ListString[] result = new ArrayListString[](); int rowSize = 0; BufferedInputStream in = new BufferedInputStream(new FileInputStream(file)); POIFSFileSystem fs = new POIFSFileSystem(in); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFCell cell = null; for (int sheetIndex = 0; sheetIndex wb.getNumberOfSheets(); sheetIndex++) { HSSFSheet st = wb.getSheetAt(sheetIndex); for (int rowIndex = firstrow; rowIndex = st.getLastRowNum(); rowIndex++) { HSSFRow row = st.getRow(rowIndex); if (row == null) { continue; } int tempRowSize = row.getLastCellNum() + 1; if (tempRowSize rowSize) { rowS