java 工具类 excel 基于poi

package com.cmh.util; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.List; import jxl.Cell; import jxl.Workbook; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.HSSFColor; public class POIExcelHelper { /** * 设置表头样式 * @param workbook * @return */ public static HSSFCellStyle getTitleStyle(HSSFWorkbook workbook) { HSSFFont font = workbook.createFont(); font.setColor(HSSFColor.BLUE.index); font.setFontHeight((short) 200); font.setFontName("楷体_GB2312"); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); HSSFCellStyle style = workbook.createCellStyle(); style.setAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); style.setFont(font); style.setFillForegroundColor(HSSFColor.GREY_50_PERCENT.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); return style; } /** * 设置表格特别数据样式 * @param workbook * @return */ public static HSSFCellStyle getDataStyle2(HSSFWorkbook workbook) { HSSFFont font = workbook.createFont(); font.setColor(HSSFColor.BLACK.index); font.setFontHeight((short) 200); font.setFontName("楷体_GB2312"); HSSFCellStyle style = workbook.createCellStyle(); style.setAlignment(HSSFCellStyle.VERTICAL_CENTER); style.setAlignment(HSSFCellStyle.ALIGN_LEFT); style.setFont(font); style.setFillForegroundColor(HSSFColor.GREY_40_PERCENT.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); return style; } /** * 创建单元格内容 * @param row * @param id * @param value * @param style */ public static void createCell(HSSFRow row, int id, String value, HSSFCellStyle style) { HSSFCell cell = row.createCell(id); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue(value); if (style != null) { cell.setCellStyle(style); } } /** * 创建报表文件 * @param workbook * @param dir * @param filename * @throws IOException */ public static void createFile(HSSFWorkbook workbook, String dir, String filename) throws IOException { dir = dir == null ? "" : dir.trim(); if( !"".equals(dir) ){ if( !dir.endsWith(File.separator) ){ dir += File.separator ; } } File outdir = new File(dir); if (!outdir.exists()) { outdir.mkdirs(); } FileOutputStream fOut = new FileOutputStream(dir + filename); workbook.write(fOut); fOut.flush(); fOut.close(); } /** * 读取Excel中所有的列 * @param filename * @return * @throws IOException */ private static List<Cell[]> jxlGetExcelColumns(String filename) throws IOException { InputStream is = null; jxl.Workbook rwb = null; List<Cell[]> list = new ArrayList<Cell[]>(); try { is = new FileInputStream(filename); rwb = Workbook.getWorkbook(is); // Sheet[] sheets = rwb.getSheets(); // int sheetLen = sheets.length; jxl.Sheet rs = rwb.getSheet(0); // 读取第一个工作表的数据 //getRows() 获取总共多少列...getColumn(n)获取第n列... for(int i=0; i<rs.getColumns(); i++ ){ list.add(rs.getColumn(i)); } } catch (Exception ex) { ex.printStackTrace(); } finally { rwb.close(); is.close(); } return list; } /** * 读取Excel中所有的行 * @param filename * @return */ private static List<Cell[]> jxlGetExcelRows(String filename) { InputStream is = null; jxl.Workbook rwb = null; List<Cell[]> list = new ArrayList<Cell[]>(); try { is = new FileInputStream(filename); rwb = Workbook.getWorkbook(is); // Sheet[] sheets = rwb.getSheets(); // int sheetLen = sheets.length; jxl.Sheet rs = rwb.getSheet(0); // 默认先读取第一个工作表的数据 //getRows() 获取总共多少行...getRow(n)获取第n行... for(int i=0; i<rs.getRows(); i++ ){ list.add(rs.getRow(i)); } } catch (Exception ex) { ex.printStackTrace(); } finally { rwb.close(); try { is.close(); } catch (IOException e) { e.printStackTrace(); } } return list; } }

测试类

package com.cmh.test; import java.io.IOException; 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 com.cmh.util.POIExcelHelper; public class ExcelTest { public static void main(String[] args) { String title[][] = { {"title1","title2","title3"}, {"1","2","3"}, {"2","4","6"} }; // TODO Auto-generated method stub try { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); HSSFCellStyle style = POIExcelHelper.getTitleStyle(wb); HSSFRow row = null; for(int i = 0;i<title.length;i++){ row = sheet.createRow(i); for(int j=0;j<title[i].length;j++){ POIExcelHelper.createCell(row,j,title[i][j],style); } } POIExcelHelper.createFile(wb, "D://", "test.xls"); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

所需的包类

这里写链接内容到这里下载

还有另一个工具类 这里写链接内容