IBM的jxl方式(从数据库导出)

类别:Java 点击:0 评论:0 推荐:

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));
  }

}

这是我写的在linux上面导入excel的方式,windows里面也一样,只不过把生成文件的目录改一下,还有就是你需要下载一个lib,这个就是jxl.jar,(注:DBAccess是我写的一个连接数据库以及从数据库获取数据的一个类 )另外还有一种方式就是poi,我也写了

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