java f1_JAVA编码（19）——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);//垂直居中
}
}