JXL导出用例.docVIP

package com.mln.frame.actions; import java.io.File; import java.io.IOException; import jxl.Workbook; import jxl.format.UnderlineStyle; import jxl.write.Alignment; import jxl.write.Boolean; import jxl.write.Border; import jxl.write.BorderLineStyle; import jxl.write.DateFormat; import jxl.write.DateTime; import jxl.write.Label; import jxl.write.WritableImage; import jxl.write.Number; import jxl.write.Formula; import jxl.write.NumberFormat; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; public class TestJXL { /** * @Date 2012-02-08 * @Author wumeiku * @What testJxl */ public static void main(String[] args) throws IOException, RowsExceededException, WriteException { // TODO Auto-generated method stub WritableWorkbook wwb = Workbook.createWorkbook(new File(F://设备台账编辑.xls)); WritableSheet sheet = wwb.createSheet(test, 0); //testLabel(sheet);//添加文本类单元格 //testFormat1(sheet);//添加带有字型Format的对象 //testFormat2(sheet);//添加带有字体颜色Format的对象 //testNumber(sheet);//添加Number对象 //testNumberFormat(sheet);//添加带有format的Number对象 //testBoolean(sheet);//添加Boolean对象 //testDateTime(sheet);//添加DateTime对象 //testDateTimeFormat(sheet);//添加带有format的DateTime对象 //testFormula(sheet);//添加公式单元格 //testImage(sheet);//添加图片 //testMergeCells(sheet); //合并单元格 //testUnitStyle(sheet); //添加单元格样式 //testFontUnitFont(sheet);//天剑单元格字体样式 wwb.write();// 写入数据 wwb.close();// 关闭文件 } //添加文本类单元格 public static void testLabel(WritableSheet sheet) throws RowsExceededException, WriteException{ Label labelC = new Label(0, 0, 测试JXL文本); sheet.addCell(labelC); } //添加带有字型Format的对象 public static void testFormat1(WritableSheet sheet) throws RowsExceededException, WriteException{ WritableFont wf = new WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true); Writ