excel.java

java操作Excel的程序

package com.liha;

import java.io.*;
import java.sql.*;

import jxl.*;
import jxl.write.*;
public class excel{

//MyExecSQL 连接数据库的类

  /*========================================================
   === 函数功能:生成excel文件
   === 参    数
   ===     title：字段名称
   ===     sql： sql字符串
   ===     path：文件生成路径
  === 返 回 值:
   === 开 发 者:董政利
   === 开发时间：2004-03-16
   === 修改纪录:
   ==========================================================*/

  public void createEXCEL(String[]title,String sql,String path){

	  try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		try {
			Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test;","sa","sa");
			Statement st=conn.createStatement();
			ResultSet rs=st.executeQuery(sql);
			 int i=0;
			    int j=0;

			    	

			     //构建Workbook对象, 只读Workbook对象
			     //：创建可写入的Excel工作薄
			     WritableWorkbook wwb = Workbook.createWorkbook(new FileOutputStream(path));
			     WritableSheet ws = wwb.createSheet("sheet1", 0);

			  for( i=0;i<title.length;i++){
			       WritableFont wf = new WritableFont(WritableFont.TIMES, 12, WritableFont.BOLD, false);
			       WritableCellFormat wcfF = new WritableCellFormat(wf);
			       Label labelCF = new Label(i, 0, title[i],wcfF);
			       ws.addCell(labelCF);
			      }
			      
			     i=1;
			     while (rs.next()) {
			      for(j=1;j<=title.length;j++)
			      {
			       Label labelC = new Label(j-1,i, rs.getString(j));
			       ws.addCell(labelC);
			   }
			      i++;   
			    }
			    //写入Exel工作表
			    wwb.write();
			    //关闭Excel工作薄对象
			    wwb.close();
			    rs.close();
			  
			  }
			  catch (Exception e) {
			    System.out.println(e.toString());
			  }
			
		} 
	  
   
}