JAVA 与 EXCEL的完美整合工具：JXL

本文只是介绍jxl.jar，不做技术层次的讨论。至于技术留到下篇文章进行讨论。

 jxl.jar 下载的链接:
http://sourceforge.net/projects/jexcelapi/

在下载包里有C#和JAVA的，不要被它的名字给吓到了（名字竟然说是for C#的！！）

至于添加LIB之类的工作就不多说了（大家用java到这个份上，应该也不需要了。呵呵）

直接来个简单例子：

package ts;
import java.io.FileOutputStream;
import java.io.OutputStream;

import jxl.Workbook;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class JxlTest {
 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下
   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;
   for (int i=0; i <title.length; i++) {
    //Label(列号,行号 ,内容 )
    label = new jxl.write.Label(i, 0, title[i]);
    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(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;

  //将cmd的第一个参数改成excel.exe的路径
  String cmd[] = { "F://Program Files//Microsoft Office//OFFICE11//EXCEL.EXE ", "c:/out.xls "};
  try{
   p = r.exec(cmd);
  }
  catch(Exception e){
   System.out.println( "error executing: "+cmd[0]);
  }
 }
}

以上程序将在C盘根目录下生成一个out.xls文件，可以看到以上代码所设置的样式。如下：

附加两个样式参照：

1.单元格边框样式：

2.单元格背景样式：

最后，补充一个小例子，在该例子中，展示了app和web中应用jxl进行数据保存的全部代码.可以将web网页中的table数据保存到本地excel文件中.

        下载:实例