java poi实excel导入导出.docVIP

所用的是poi jar Java数据导入Excel package com.bossy.base;import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.util.ArrayList; import java.util.List; import jxl.Workbook; import jxl.format.UnderlineStyle; import jxl.write.Label; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; 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 ExcelOpt { /** ? * 生成一个Excel文件 jxl ???? * @param fileName? 要生成的Excel文件名 ???? * @jxl.jar 版本：2.6 ???? */? ??? public static void writeExcel(String fileName){?? ??????? WritableWorkbook wwb = null;?? ??????? try {?? ??????????? //首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象?? ??????????? wwb = Workbook.createWorkbook(new File(fileName)); ????????? ??????? } catch (IOException e) {?? ??????????? e.printStackTrace();?? ??????? }?? ??????? if(wwb!=null){?? ??????????? //创建一个可写入的工作表?? ??????????? //Workbook的createSheet方法有两个参数，第一个是工作表的名称，第二个是工作表在工作薄中的位置?? ??????????? WritableSheet ws = wwb.createSheet(工作表名称, 0);?? ?????????????? ??????????? //下面开始添加单元格?? ??????????? for(int i=0;i10;i++){?? ??????????????? for(int j=0;j5;j++){?? ??????????????????? //这里需要注意的是，在Excel中，第一个参数表示列，第二个表示行?? ??????????????????? Label labelC = new Label(j, i, 这是第+(i+1)+行，第+(j+1)+列); ??????????????????? try {?? ??????????????????????? //将生成的单元格添加到工作表中?? ??????????????????????? ws.addCell(labelC);?? ??????????????????? } catch (RowsExceededException e) {?? ??????????????????????? e.printStackTrace();?? ??????????????????? } catch (WriteException e) {?? ??????????????????????? e.