excel的读写操作.pdf

2010.03.17(3)——大数据导出excel 之html package test; import java.io.FileOutputStream; import java.io.OutputStream; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Date; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import util.JdbcUtil; /** * 这种html 的方式导出速度太慢了 * * */ public class ExcelTest3 { public static void main(String[] args) throws Exception{ FileOutputStream out = new FileOutputStream(C:/workbook3.xls); long a = System.currentTimeMillis(); exportToExcel(out); long b = System.currentTimeMillis(); System.out.println((b-a)/1000+秒); } public static void exportToExcel(OutputStream out) throws Exception{ //获得数据库连接 Connection con = JdbcUtil.getConnection(); //获得Statement Statement stm = con.createStatement(); //执行查询 ResultSet rs = stm.executeQuery(select * from st_rsvrfsr_b); SimpleDateFormat df = new SimpleDateFormat(yyyy-MM-dd hh:mm:ss); String str = html xmlns:o=urn:schemas-microsoft-com:office:office+ xmlns:x=urn:schemas-microsoft-com:office:excel+ xmlns=/TR/REC-html40+ head+ meta http-equiv=Content-Type content=text/html; charset=gb2312+ meta name=ProgId content=Excel.Sheet+ meta name=Generator content=Microsoft Excel 11+ link rel=File-List href=1111.files/filelist.xml+ link rel=Edit-Time-Data href=1111.files/editdata.mso+ link rel=OLE-Object-Data href=1111.files/oledata.mso+ !--[if gte mso 9]xml+ o:DocumentProperties+ o:Created1996-12-17T01:32:42Z/o:Created+ o:LastSaved2010-03-17T06:50:36Z/o:LastSaved+ o:Version11.5606/o:Version+ /o:DocumentProperties+ o:Off