semovy

package com.semovy.test;

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下
   // 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",
    targetfile };
  try {
   p = r.exec(cmd);
  } catch (Exception e) {
   System.out.println("error executing: " + cmd[0]);
  }

 }

}