JAVA编码（35）—— java使用f1j9swing来生成excel文件

工程需要引入 f1j9swing.jar包

执行导出Excel案例：详见360云盘,“经典详例Demo”


package sinosoft_xsy;

import java.io.IOException;

import com.f1j.ss.BookModelImpl;
import com.f1j.ss.CellFormat;
import com.f1j.ss.Constants;
import com.f1j.ss.WriteParams;
import com.f1j.util.F1Exception;

public class Sinosoft {
    
    static CellFormat mCellFormat = new CellFormat();
    static CellFormat mLeftTopCF = new CellFormat();
    static CellFormat mInputCF = new CellFormat();
    
    public static void main(String[] args) {
        testExcel();
    }
    
    /**
     * 使用f1j9swing来生成excel
     */
    public static void testExcel(){
        BookModelImpl book = new BookModelImpl();
        BookModelImpl modelBook = new BookModelImpl();
        try {
            book.initWorkbook();
            setCellFormat();
            
            //读取已有的模板
            modelBook.read("E:\\workspace3.7\\gs_acc\\hkcwweblogic\\account\\yd_work\\BulletinReport\\BulletinReport_1.xls");
            //读取模版Excel，所有cell的样式在这里面定义好   ，每生成一个sheet就copy下，最省事
            book.copyRange(0, 0, modelBook.getLastRow(), modelBook.getLastCol(), modelBook, 
                    0, 0, modelBook.getLastRow(), modelBook.getLastCol(), Constants.eCopyAll);
            for (int i = 0; i <= modelBook.getLastCol(); i++) {
                book.setColWidth(i, modelBook.getColWidth(i));//设置列宽，即模板中的列为多宽，则生成的excel的列也为多宽
            }
            book.setText(2,0,"2015年05月21日");
            for (int m = 9; m <= 34; m++) {//实际要显示的xls要放值的开始行和结束行
                System.out.println(m);
                book.setNumber(m-1, 3, 11);
                book.setNumber(m-1, 4, 11);
                book.setNumber(m-1, 5, 11);
            }    
            book.setSheetName(0, "本季度快报");
            book.insertSheets(0, 1);
            // Excel文件输出
            book.write("E:\\workspace3.7\\gs_acc\\hkcwweblogic\\account\\yd_work\\BulletinReport\\BulletinReport_111111.xls", new WriteParams(BookModelImpl.eFileExcel97));// Excel文件输出
        } catch (OutOfMemoryError e) {
            e.printStackTrace();
        } catch (F1Exception e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    
    public static void setCellFormat() throws F1Exception{
        //生成单元格格式
        mCellFormat.setLeftBorder(CellFormat.eBorderThin);
        mCellFormat.setRightBorder(CellFormat.eBorderThin);
        mCellFormat.setTopBorder(CellFormat.eBorderThin);
        mCellFormat.setBottomBorder(CellFormat.eBorderThin);
        mCellFormat.setVerticalInsideBorder(CellFormat.eBorderThin);
        mCellFormat.setFontName("宋体");
        //左上角格式
        mLeftTopCF.setFontName("宋体");
        mLeftTopCF.setFontSize(200);//10号
        mLeftTopCF.setFontBold(true);//粗体
        mLeftTopCF.setHorizontalAlignment(CellFormat.eHorizontalAlignmentLeft);//居左
        mLeftTopCF.setVerticalAlignment(CellFormat.eVerticalAlignmentCenter);//垂直居中
        //输入数据的单元格的格式
        mInputCF.setLeftBorder(CellFormat.eBorderThin);
        mInputCF.setRightBorder(CellFormat.eBorderThin);
        mInputCF.setTopBorder(CellFormat.eBorderThin);
        mInputCF.setBottomBorder(CellFormat.eBorderThin);
        mInputCF.setFontName("宋体");
        mInputCF.setFontSize(200);
        mInputCF.setHorizontalAlignment(CellFormat.eHorizontalAlignmentCenter);//居中
        mInputCF.setVerticalAlignment(CellFormat.eVerticalAlignmentCenter);//垂直居中
    }
}