java中导出数据到excel中例子

《java中导出数据到excel中例子》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、packagenet.risesoft.formula;importjava.io.FileOutputStream;importjava.io.OutputStream;importjava.io.PrintWriter;importjava.util.ArrayList;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importorg.apache.poi.hssf.use

2、rmodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFCellStyle;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.hssf.util.HSSFColor;importcom.oreilly.servlet.MultipartRequest;impo

3、rtnet.coin.db.DBManager;importnet.coin.db.result.Result;importnet.coin.servlet.Context;importnet.risesoft.formulamanager.ChkFormulaCode;importnet.risesoft.system.InstitutionHelper;importnet.risesoft.task.TaskHelper;publicclassFormulaExportServletextendsHttpServlet{staticfinalprivateStringCONT

4、ENT_TYPE="application/vnd.ms-excel;charset=gbk";privateString[]fieldName=null;privateStringreport_code=null;privateStringtaskId=null;privateStringformualTableName=null;privateStringsystem_code=null;privateStringtjStr="";privateStringcolStr="";/*************************************************

5、*********************************************************************************************************/publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse){doPerform(request,response);}/*************************************************************************************

6、*********************************************************************/publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse){doPerform(request,response);}privateStringgetFileName(HttpServletRequestrequest,Stringreport_code)throwsException{StringreportTableName="rpt_report_"+th

7、is.taskId;StringtableName=DBManager.query("selectt.report_namefrom"+reportTableName+"twheret.report_code='"+report_code+"'").forFirstString("report_name");returntableName;}/*********************************************************************