例子:(来自:http://www.iteye.com/problems/54701)
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class TestExcel {
private String driverClass = "net.sourceforge.jtds.jdbc.Driver";
private String url ="jdbc:jtds:sqlserver:/localhost:1433/demo";
private String user = "sa";
private String password = "";
private Connection connection;
public void exportClassroom(OutputStream os) {
try {
WritableWorkbook wbook = Workbook.createW