java查询数据转换excel_数据转换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