利用JXL导出含有格式的EXCEL文件

利用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....");
	}
}

 

 

每天一点点希望对大家有利~