基于poi的Excel读入和写出 代码直接可用 需要下载poi.jar包.doc

package test;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.text.NumberFormat;import java.util.ArrayList;import java.util.List;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;public class ExcelLoadAndPut /默认情况下读取的Excel表格 放到一个list里面 一行的分割符为(&)private final String ss=Sheet1;/* * 读取Excel表格内容 返回一个list集合 * param fliepath 读取文件的路径 * param sheetName 读取指定的表格 默认为Sheet1 */SuppressWarnings(unchecked)public List LoadExcel(String filePath, String sheetName)/存放excel表格里数据 一个object数组为一行excel数据List list=new ArrayList();HSSFWorkbook workbook=null;/输入流InputStream is = null;/工作表HSSFSheet sheet=null;tryis = new FileInputStream(filePath); workbook = new HSSFWorkbook(is); catch(FileNotFoundException e) e.printStackTrace();catch(IOException e)e.printStackTrace();if(sheetName=null|sheetName.equals() sheet=workbook.getSheet(ss);else sheet=workbook.getSheet(sheetName); String str=; for(int i = 0; i sheet.getPhysicalNumberOfRows(); i+) HSSFRow row = sheet.getRow(i); Object obj=new Objectrow.getPhysicalNumberOfCells(); for(int j=0;jrow.getPhysicalNumberOfCells();j+) HSSFCell cell=row.getCell(short)j); try switch(cell.getCellType() case HSSFCell.CELL_TYPE_STRING: str = cell.getStringCellValue(); break; case HSSFCell.CELL_TYPE_NUMERIC: NumberFormat nf = NumberFormat.getInstance(); nf.setGroupingUsed(false); double acno=cell.getNumericCellValue(); str = nf.format(acno); break; case HSSFCell.CELL_TYPE_FORMULA: str = String.valueOf(cell.getNumericCellValue(); break; case HSSFCell.CELL_TYPE_BLANK: str = ; break; case HSSFCell.CELL_TYPE_BOOLEAN: break; default : str=; break; catch (Exception e) continue; objj=str;/ System.out.print(obji+,); str=; list.add(obj); /测试用for(int j=0;jlist.size();j+)Object object=list.get(j);for(int m=0;mobject.length;m+)Object o=objectm;System.out.print(o+,); System.out.println();try is.close(); catch (IOException e) e.printStackTrace(); return list; /* * 将数据写入到指定的目录的excel表里 * param fliepath 文件路径 * param sheetName 指定的表 默认为sheet1 * param list 写入表格的数据集合 */ SuppressWarnings( unchecked, hiding ) public void PutExcel(String fliePath,String sheetName,List list) HSSFWorkbook workbook=new HSSFWorkbook(); FileOutputStream fos=null; try fos=new FileOutputStream(fliePath); catch(FileNotFoundException e) e.printStackTrace(); catch(IOException e) e.printStackTrace(); HSSFSheet sheet=null; if(sheetName=null|sheetName.equals() sheet=workbook.createSheet(ss); else sheet=workbook.createSheet(sheetName); HSSFRow row = sheet.createRow(0); int g=0; for(int i=0;ilist.size();i+) Object obj=list.get(i); row = sheet.createRow(i); for(int m=0;mobj.length;m+) HSSFCell cell = row.createCell(short) g); g+; cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(objm.toString(); g=0; try workbook.write(fos);fos.close(); catch (IOException e) e.prin