JXL导出用例.doc

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, WriteExceptionLabel labelC = new Label(0, 0, 测试JXL文本);sheet.addCell(labelC);/添加带有字型Format的对象public static void testFormat1(WritableSheet sheet) throws RowsExceededException, WriteExceptionWritableFont wf = new WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true);WritableCellFormat wcfF = new WritableCellFormat(wf);Label labelf = new Label(1,0,测试JXL字型,wcfF);sheet.addCell(labelf);/添加带有字体颜色Format的对象public static void testFormat2(WritableSheet sheet) throws RowsExceededException, WriteExceptionWritableFont wfc = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD, false,UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);WritableCellFormat wcfFC = new WritableCellFormat(wfc);Label labelCFC = new Label(2, 1, 测试JXL字体颜色, wcfFC);sheet.addCell(labelCFC);/添加Number对象public static void testNumber(WritableSheet sheet) throws RowsExceededException, WriteException Number labelN = new Number(0, 1, 3.1415926); sheet.addCell(labelN);/添加带有format的Number对象public static void testNumberFormat(WritableSheet sheet) throws RowsExceededException, WriteExceptionNumberFormat nf = new NumberFormat(#.#);WritableCellFormat wcfN = new WritableCellFormat(nf);Number labelN = new Number(0, 1, 3.1415926,wcfN); sheet.addCell(labelN);/添加Boolean对象public static void testBoolean(WritableSheet sheet) throws RowsExceededException, WriteExceptionBoolean labelB = new Boolean(0, 2, false);sheet.addCell(labelB);/添加DateTime对象public static void testDateTime(WritableSheet sheet) throws RowsExceededException, WriteExceptionDateTime labelDT = new DateTime(0, 3, new java.util.Date();sheet.addCell(labelDT);/添加带有format的DateTime对象public static void testDateTimeFormat(WritableSheet sheet) throws RowsExceededException, WriteExceptionDateFormat df = new DateFormat(dd MM yyyy hh:mm:ss);WritableCellFormat wcfDF = new WritableCellFormat(df);DateTime labelDTF = new DateTime(1, 3, new java.util.Date(), wcfDF);sheet.addCell(labelDTF);/添加公式单元格(暂时无法实现)public static void testFormula(WritableSheet sheet) throws RowsExceededException, WriteExceptionNumber labelN1 = new Number(0, 0, 3);Number labelN2 = new Number(0, 1, 4);sheet.addCell(labelN1);sheet.addCell(labelN2);Formula formual = new Formula(0,11,Sum(A1:A9);sheet.addCell(formual);/添加imagepublic static void testImage(WritableSheet sheet) throws RowsExceededException, WriteExceptionWritableImage wrimage=new WritableImage(1,5,10,10,new File(F:/enconding配置.png);sheet.addImage(wrimage);/合并单元格public static void testMergeCells(WritableSheet sheet) throws RowsExceededException, WriteException sheet.mergeCells(0, 0, 9, 0); Label label = new Label(0, 0, 合并了12个单元格); sheet.addCell(label);/添加单元格样式public static void testUnitStyle(WritableSheet sheet) throws RowsExceededException, WriteException WritableCellFormat wc = new WritableCellFormat(); wc.setAlignment(Alignment.CENTRE); / 设置居中 wc.setBorder(Border.ALL, BorderLineStyle.THIN); / 设置边框线 wc.setBackground(jxl.format.Colour.RED); / 设置单元格的背景颜色 Label label = new Label(1, 5, 字体, wc); sheet.addCell(label);/添加单元格字体样式public static void testFontUnitFont(WritableShee