数据转换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