基于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表格内容 返回一个listobject[]集合 * @param fliepath 读取文件的路径 * @param sheetName 读取指定的表格 默认为Sheet1 */ @SuppressWarnings(unchecked) public ListObject[] LoadExcel(String filePath, String sheetName){ //存放excel表格里数据 一个object数组为一行excel数据 ListObject[] list=new ArrayListObject[](); HSSFWorkbook workbook=null; //输入流 InputStream is = null; //工作表 HSSFSheet sheet=null; try{ is = 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 Object[row.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.g