利用JXL导出带有格式的EXCEL文件
下面是带有格式导出的EXCEL文件的代码：
import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStream;import jxl.Workbook;import jxl.write.*;import jxl.write.Number;public class ExcelExport {public static void main(String [] args){String targetfile="f:/excel.xls";String worksheet="List";String [] title={"ID","NAME","DESCRIB"};WritableWorkbook workbook;Label label;Number number;System.out.println("BEGIN....");try {OutputStream os=new FileOutputStream(targetfile);workbook=Workbook.createWorkbook(os);WritableSheet sheet=workbook.createSheet("MySheet", 1);for(int i=0;i<title.length;i++){label=new Label(i,0,title[i]);sheet.addCell(label);}number =new jxl.write.Number(3,4,3.1415926);sheet.addCell(number);//添加带有字型Formatting的对象WritableFont wf=new jxl.write.WritableFont(WritableFont.TIMES,10,WritableFont.BOLD,true);WritableCellFormat wcfF=new jxl.write.WritableCellFormat(wf);Label labelCF=new Label(4,4,"文本",wcfF);sheet.addCell(labelCF);//添加带有字体颜色，带有背景颜色Formatting的对象WritableFont wfc=new WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD,false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.RED);WritableCellFormat wcfFC=new WritableCellFormat(wfc);wcfFC.setBackground(jxl.format.Colour.BLUE);Label labelCFC=new Label(1,5,"带颜色",wcfFC);sheet.addCell(labelCFC);//添加带有formatting的Number对象NumberFormat nf=new NumberFormat("#.##");WritableCellFormat wcfN=new WritableCellFormat(nf);Number labelNF=new Number(1,1,3.1415926,wcfN);sheet.addCell(labelNF);//添加Boolean对象jxl.write.Boolean labelB=new jxl.write.Boolean(0,2,false);sheet.addCell(labelB);//添加DateTime 对象jxl.write.DateTime labelDT=new jxl.write.DateTime(0,3,new java.util.Date());sheet.addCell(labelDT);//添加带有formatting 的DateFormat对象jxl.write.DateFormat df=new jxl.write.DateFormat("ddMMyyyyhh:mm:ss");jxl.write.WritableCellFormat wcfDF=new jxl.write.WritableCellFormat(df);jxl.write.DateTime labelDTF=new jxl.write.DateTime(1,3,new java.util.Date(),wcfDF);sheet.addCell(labelDTF);//合并单元格sheet.mergeCells(4, 5, 8, 10);wfc=new jxl.write.WritableFont(WritableFont.ARIAL,40,WritableFont.BOLD,false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.GREEN);jxl.write.WritableCellFormat wchB=new jxl.write.WritableCellFormat(wfc);wchB.setAlignment(jxl.format.Alignment.CENTRE);labelCFC=new Label(4,5,"单元格合并",wchB);sheet.addCell(labelCFC);//设置边框jxl.write.WritableCellFormat wcsB=new jxl.write.WritableCellFormat();wcsB.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THICK);labelCFC=new Label(0,6,"边框设置",wcsB);sheet.addCell(labelCFC);workbook.write();workbook.close();} catch (Exception e) {e.printStackTrace();}System.out.println("end....");}}?
?
每天一点点希望对大家有利~