Êý¾Ýת»»excelµÄjava³ÌÐò

 ÒªÓõ½jxlµÄ°ü
¾ßÌåʵÀý
1.Éú³ÉexcelÎļþ
package com.createexcel;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.mysql.jdbc.ResultSetMetaData;
import jxl.Workbook;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import com.bean.DataInfo;
public class CreateExcel {
  
 public void CreateExcel(String targetfile,String start,String end) {
    
            String worksheet = "ÈÕÖ¾Êä³ö";       //Êä³öµÄexcelÎļþ¹¤×÷±íÃû
     GetDataInfo data=new GetDataInfo();
     List list=new ArrayList();
     list=data.getdata(start,end);
     if(list.size()!=0){
        int colCount=0;
        TestDao test=new TestDao();
        ResultSet  rs = test.selectSql("SELECT * from datainfo");                                        
       
            WritableWorkbook workbook;
      try{
 System.out.println("begin");
 //´´½¨¿ÉдÈëµÄExcel¹¤×÷±¡,ÔËÐÐÉú³ÉµÄÎļþÔÚtomcat/binÏÂ
 //workbook = Workbook.createWorkbook(new File("output.xls"));
 OutputStream os=new FileOutputStream(targetfile);
 workbook=Workbook.createWorkbook(os);
 WritableSheet sheet = wo