excel技巧

String str_value=temp.replaceAll("[\\\n\\\t]"," ");
sb.append(str_value).append((char)9);
}
}
}catch(Exception e) {
sb.append("生成数据出错!");
*/
public String getCsv(String str_sql,String title,String str_head) {
StringBuffer sb=new StringBuffer();
Connection conn=null;
sb.append("\n");
for(int i=1;i<=rmd.getColumnCount();i++) {
String temp=rec.getString(i);
if(temp==null) {
temp="";
}
HttpSession session=httpServletRequest.getSession();
HashMap hm=(HashMap)session.getAttribute("gzmas_popedom");
try {
OutputStream os=httpServletResponse.getOutputStream();
}
/**
* 使用POI生成Excel
* @param str_sql
}
/**
* 以CSV方的方式生成Excel表格
* @param str_sql
* @param title
* @return
email : pdw2009 At
blog :
*/
public class ReportAction extends DispatchAction{
HttpServletResponse httpServletResponse) {
httpServletResponse.setContentType("application/vnd.ms-excel");
ServletRequest request=(ServletRequest)httpServletRequest;
}
out.flush();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.servlet.jsp.JspWriter;
import org.apache.struts.action.ActionForm;
e.printStackTrace();
}finally {
try {
if(rec!=null) {
rec.close();
}
if(stmt!=null) {
stmt.close();
}
Top
2 楼pdw2009（不想做菜鸟）回复于 2006-01-05 16:14:38 得分 0
import javax.servlet.ServletRequest;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
Logger logger=Logger.getLogger(ReportAction.class);
public void excelReport(ActionMapping actionMapping,
ActionForm actionForm, HttpServletRequest httpServletRequest,
String[] ary = str_head.split(",");
for(int k=0;k<ary.length;k++) {
sb.append(ary[k]).append((char)9);
}
while(rec.next()) {
String str_sql=request.getParameter("str_query");
String str_title=request.getParameter("str_title");
String str_head=request.getParameter("strGridTitle");
String str_sql= (String) request.getParameter("strquery");
String str_title=request.getParameter("strtitle");
String str_head=request.getParameter("strGridTitle");
import ermodel.*;
import java.io.*; Nhomakorabea import mon.hibernate.*;
/**
Author peiDW 保留署名权
os.write(bytes);
}else {
os.write(getWorkbook(str_sql,str_title,str_head).getBytes());
}
os.flush();
os.close();
} catch (IOException e) {
我也用的是POI生成Excel文件,
由于表格比较复杂,我采用了Excel模板,因此只要把数据填到表格内再适当修改某些单格样式就可以了, 但由于表格太复杂, 每次超过1000条记录就会内存溢出.
我觉得如果表格不是很复杂,可以生成CSV文件,这样速度快很多,也不会出现内存溢出的情况.
Session session=null;
Statement stmt=null;
ResultSet rec=null;
try {
session=CommonUtils.currentSession();
conn=session.connection();
CommonUtils.closeSession();
}catch(Exception e) {
//logg.er.error(e);
e.printStackTrace();
}
}
return sb.toString();
HttpServletResponse httpServletResponse) {
httpServletResponse.setContentType("application/vnd.ms-excel;charset=gb2312");
ServletRequest request=(ServletRequest)httpServletRequest;
stmt=conn.createStatement();
rec=stmt.executeQuery(str_sql);
ResultSetMetaData rmd=rec.getMetaData();
sb.append(" "+title+" ").append("\n");
HttpSession session=httpServletRequest.getSession();
HashMap hm=(HashMap)session.getAttribute("gzmas_popedom");
try {
PrintWriter out=httpServletResponse.getWriter();
if(hm==null||!hm.containsKey("Report_Manager")) {
String a="你没有权限，所以不能获取数据!";
byte bytes[]=new byte[a.length()];
bytes=a.getBytes();
e.printStackTrace();
}
//return null;
}
public void csvReport(ActionMapping actionMapping,
ActionForm actionForm, HttpServletRequest httpServletRequest,
if(hm==null||!hm.containsKey("Report_Manager")) {
out.println("你没有权限，所以不能获取数据!");