IBM的jxl方式（从数据库导出） 选择自 geyu 的 Blog

IBM的jxl方式：
package excelfile;
import java.text.DateFormat;
import java.util.*;
import java.io.*;
import jxl.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Jxlcreateexcel {
  public Jxlcreateexcel() {
  }

  public void getExcelFile() {
    String tableName = "EXCEL_OUTPUT_TEST_REALDATA_2";
    String im = "";
    String sid = "oral";
    String server = "10.254.100.25";
    String whereItem = "rownum <3375";
    try {
      jxl.write.WritableWorkbook book = Workbook.createWorkbook(new File(
          "/home/ljz/filestest/jxlEXCEL_OUTPUT_TEST_REALDATA_2.xls"));
      jxl.write.WritableSheet sh = book.createSheet("jxltest", 0);
      DBAccess dbaccess = new DBAccess();
      dbaccess.setSelectItems(tableName);
      dbaccess.setSid(sid);
      dbaccess.setServer(server);
      dbaccess.setItems(im);
      dbaccess.setWhereItem(whereItem);
      Hashtable sels = null;
      sels = dbaccess.getSelectData();
      int hashElement = sels.size();
      for (int y = 0; y < hashElement; y++) {
        Vector items = (Vector) sels.remove(String.valueOf(y));
        for (int x = 0; x < items.size(); x++) {
          jxl.write.Label labelCell = new jxl.write.Label(x, y,
              (String) items.get(x));
          sh.addCell(labelCell);
          labelCell = null;
        }
      }
      book.write();
      book.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public static void main(String args[]) {
    Date time = new Date();
    DateFormat fullDateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG,DateFormat.LONG);
    System.out.println("The process start time:"+fullDateFormat.format(time));
    Jxlcreateexcel jxlexcle = new Jxlcreateexcel();
    try {
      jxlexcle.getExcelFile();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    Date time1 = new Date();
    System.out.println("The process end time:"+fullDateFormat.format(time1));
  }

}

本文地址：http://com.8s8s.com/it/it11609.htm