|
jxl不錯，簡單易用
import?jxl.*;
import?jxl.write.*;
import?java.io.*;
import?java.io.File.*;
import?java.util.*;
public?class?excel
{
public?static?void?main(String[]?args)?
{
String?targetfile?=?"c:/out.xls";//輸出的excel文件名
String?worksheet?=?"List";//輸出的excel文件工作表名
String[]?title?=?{"ID","NAME","DESCRIB"};//excel工作表的標題
WritableWorkbook?workbook;
try
{
//創建可寫入的Excel工作薄,運行生成的文件在tomcat/bin下
//workbook?=?Workbook.createWorkbook(new?File("output.xls"));?
System.out.println("begin");
OutputStream?os=new?FileOutputStream(targetfile);?
workbook=Workbook.createWorkbook(os);?
WritableSheet?sheet?=?workbook.createSheet(worksheet,?0);?//添加第一個工作表
//WritableSheet?sheet1?=?workbook.createSheet("MySheet1",?1);?//可添加第二個工作
/*
jxl.write.Label?label?=?new?jxl.write.Label(0,?2,?"A?label?record");?//put?a?label?in?cell?A3,?Label(column,row)
sheet.addCell(label);?
*/
jxl.write.Label?label;
for?(int?i=0;?i<title.length;?i++)
{
//Label(列號,行號?,內容?)
label?=?new?jxl.write.Label(i,?0,?title[i]);?//put?the?title?in?row1?
sheet.addCell(label);?
}
//下列添加的對字體等的設置均調試通過，可作參考用
//添加數字
jxl.write.Number?number?=?new?jxl.write.Number(3,?4,?3.14159);?//put?the?number?3.14159?in?cell?D5
sheet.addCell(number);
//添加帶有字型Formatting的對象?
jxl.write.WritableFont?wf?=?new?jxl.write.WritableFont(WritableFont.TIMES,10,WritableFont.BOLD,true);?
jxl.write.WritableCellFormat?wcfF?=?new?jxl.write.WritableCellFormat(wf);?
jxl.write.Label?labelCF?=?new?jxl.write.Label(4,4,"文本",wcfF);?
sheet.addCell(labelCF);?
//添加帶有字體顏色,帶背景顏色?Formatting的對象?
jxl.write.WritableFont?wfc?=?new?jxl.write.WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD,false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.RED);?
jxl.write.WritableCellFormat?wcfFC?=?new?jxl.write.WritableCellFormat(wfc);?
wcfFC.setBackground(jxl.format.Colour.BLUE);
jxl.write.Label?labelCFC?=?new?jxl.write.Label(1,5,"帶顏色",wcfFC);?
sheet.addCell(labelCFC);?
//添加帶有formatting的Number對象?
jxl.write.NumberFormat?nf?=?new?jxl.write.NumberFormat("#.##");?
jxl.write.WritableCellFormat?wcfN?=?new?jxl.write.WritableCellFormat(nf);?
jxl.write.Number?labelNF?=?new?jxl.write.Number(1,1,3.1415926,wcfN);?
sheet.addCell(labelNF);?
//3.添加Boolean對象?
jxl.write.Boolean?labelB?=?new?jxl.write.Boolean(0,2,false);?
sheet.addCell(labelB);?
//4.添加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(int?col1,int?row1,int?col2,int?row2);//左上角到右下角
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?jxl.write.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?jxl.write.Label(0,6,"邊框設置",wcsB);?
sheet.addCell(labelCFC);?
workbook.write();?
workbook.close();
}catch(Exception?e)?
{?
e.printStackTrace();?
}?
System.out.println("end");
Runtime?r=Runtime.getRuntime();?
Process?p=null;?
//String?cmd[]={"notepad","exec.java"};?
String?cmd[]={"C:\\Program?Files\\Microsoft?Office\\Office\\EXCEL.EXE","out.xls"};?
try{?
p=r.exec(cmd);?
}?
catch(Exception?e){?
System.out.println("error?executing:?"+cmd[0]);?
}
}
}
|