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