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

要用到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

免费搭建微信查券返利机器人来轻松赚佣金