poi 写 2003,2007 excel

编程技术  /  houtizong 发布于 3年前   61

这段代码是poi官网上给的，不过里面有些变量重复定义，我稍微改了下

注意，此代码是在 poi-3.7-20101029.jar 下

package com.club.community.util;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellStyle;import org.apache.poi.ss.usermodel.CreationHelper;import org.apache.poi.ss.usermodel.DataFormat;import org.apache.poi.ss.usermodel.Font;import org.apache.poi.ss.usermodel.IndexedColors;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class CreateExcel {public static void main(String[] args) {CreateExcel.crateExcel();}public static void crateExcel() {Workbook[] wbs = new Workbook[] { new HSSFWorkbook(), new XSSFWorkbook() };for(int i=0; i<wbs.length; i++) {   Workbook wb = wbs[i];   CreationHelper createHelper = wb.getCreationHelper();   // create a new sheet   Sheet s = wb.createSheet();   // declare a row object reference   Row r = null;   // declare a cell object reference   Cell c = null;   Cell c2 = null;   // create 2 cell styles   CellStyle cs = wb.createCellStyle();   CellStyle cs2 = wb.createCellStyle();   DataFormat df = wb.createDataFormat();   // create 2 fonts objects   Font f = wb.createFont();   Font f2 = wb.createFont();   // Set font 1 to 12 point type, blue and bold   f.setFontHeightInPoints((short) 12);   f.setColor( IndexedColors.RED.getIndex() );   f.setBoldweight(Font.BOLDWEIGHT_BOLD);   // Set font 2 to 10 point type, red and bold   f2.setFontHeightInPoints((short) 10);   f2.setColor( IndexedColors.RED.getIndex() );   f2.setBoldweight(Font.BOLDWEIGHT_BOLD);   // Set cell style and formatting   cs.setFont(f);   cs.setDataFormat(df.getFormat("#,##0.0"));   // Set the other cell style and formatting   cs2.setBorderBottom(CellStyle.BORDER_THIN);   cs2.setDataFormat(df.getFormat("text"));   cs2.setFont(f2);   // Define a few rows   for(int rownum = 0; rownum < 30; rownum++) {   r = s.createRow(rownum);   for(int cellnum = 0; cellnum < 10; cellnum += 2) {   c = r.createCell(cellnum);   c2 = r.createCell(cellnum+1);      c.setCellValue((double)rownum + (cellnum/10));   c2.setCellValue(   createHelper.createRichTextString("Hello! " + cellnum + "马宏敏"));   }   }      // Save   String filename = "c://2222//workbook.xls";   if(wb instanceof XSSFWorkbook) {     filename = filename + "x";   }    FileOutputStream out;try {out = new FileOutputStream(filename);wb.write(out);out.close();} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}   }}}