import java.io.File;
import java.util.*;
import jxl.*;
import jxl.write.*;
/**
 * <p>Title: 操作Excel文件</p>
 * <p>Description: 本實(shí)例演示使用jxl包實(shí)現(xiàn)對excel文件的操作</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Filename: myExcel.java</p>
 * @version 1.0
 */
public class myExcel{
  Workbook workbook;
  Sheet sheet;
/**
 *<br>方法說明：寫入文件操作
 *<br>輸入?yún)?shù)：
 *<br>返回類型：
 */
  public void write(){
    try{
        //創(chuàng)建一個(gè)可寫入的excel文件對象
        WritableWorkbook workbook = Workbook.createWorkbook(new File("myfile.xls"));
        //使用第一張工作表，將其命名為“午餐記錄”
        WritableSheet sheet = workbook.createSheet("午餐記錄", 0);
        //表頭
        Label label0 = new Label(0, 0, "時(shí)間");
        sheet.addCell(label0);
        Label label1 = new Label(1, 0, "姓名");
        sheet.addCell(label1);
        Label label2 = new Label(2, 0, "午餐標(biāo)準(zhǔn)");
        sheet.addCell(label2);
        Label label3 = new Label(3, 0, "實(shí)際費(fèi)用");
        sheet.addCell(label3);
        //格式化日期
        jxl.write.DateFormat df = new jxl.write.DateFormat("yyyy-dd-MM  hh:mm:ss");
        jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
        jxl.write.DateTime labelDTF = new jxl.write.DateTime(0, 1, new java.util.Date(), wcfDF);
        sheet.addCell(labelDTF);
        //普通字符
        Label labelCFC = new Label(1, 1, "riverwind");
        sheet.addCell(labelCFC);
         //格式化數(shù)字
        jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");
        WritableCellFormat wcfN = new WritableCellFormat(nf);
        jxl.write.Number labelNF = new jxl.write.Number(2, 1, 13.1415926, wcfN);
        sheet.addCell(labelNF);
       
        
        jxl.write.Number labelNNF = new jxl.write.Number(3, 1, 10.50001, wcfN);
        sheet.addCell(labelNNF);
        //關(guān)閉對象，釋放資源
        workbook.write();
        workbook.close();