poi导出excel比js导出excel安全性更好，在使用poi导出excel时，先要导入poi-3.5-FINAL-20090928.jar包到你项目的lib目录下，我这里选择是3.5版的
1.action类
package com.szallway.phr2.portal.action;
import java.io.ByteArrayInputStream;
import
java.io.ByteArrayOutputStream;
import
java.io.FileNotFoundException;
import java.io.FileOutputStream;
import
java.io.IOException;
import java.io.InputStream;
import
java.text.SimpleDateFormat;
import java.util.Date;
import
java.util.Iterator;
import java.util.List;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFRow;
import
org.apache.poi.hssf.usermodel.HSSFSheet;
import
org.apache.poi.hssf.usermodel.HSSFWorkbook;
import
org.apache.struts2.interceptor.RequestAware;
import
org.apache.struts2.interceptor.SessionAware;
import com.opensymphony.xwork2.ActionSupport;
import
com.opensymphony.xwork2.ModelDriven;
import
com.szallway.phr2.portal.factory.ServiceFactory;
import
com.szallway.phr2.portal.po.Account;
import
com.szallway.phr2.portal.po.Counter;
import
com.szallway.phr2.portal.po.Friend;
import
com.szallway.phr2.portal.po.Healthbackground;
import
com.szallway.phr2.portal.po.Permission;
import
com.szallway.phr2.portal.po.Profile;
import
com.szallway.phr2.portal.service.CounterService;
import
com.szallway.phr2.portal.service.FriendService;
import
com.szallway.phr2.portal.service.HealthbackgroundService;
import
com.szallway.phr2.portal.service.PermissionService;
import
com.szallway.phr2.portal.service.ProfileService;
import
com.szallway.phr2.portal.util.ProfileIDGender;
public class FriendAction extends ActionSupport implements
SessionAware,RequestAware, ModelDriven{
private Map<String,
Object> session;
private Map<String, Object>
request;
private Friend
friend;
private String
areacode;
private int
profid;
private InputStream
excelStream; //定义一输入流
private String
fileName; //文件名
public String getFileName() {
return
fileName;
}
public void setFileName(String fileName) {
this.fileName
= fileName;
}
public InputStream getExcelStream() {
return
excelStream;
}
public void setExcelStream(InputStream excelStream)
{
this.excelStream = excelStream;
}
public int getProfid() {
return profid;
}
public void setProfid(int profid) {
this.profid =
profid;
}
public String getAreacode() {
return
areacode;
}
public void setAreacode(String areacode) {
this.areacode
= areacode;
}
public Friend getFriend() {
return
friend;
}
public void setFriend(Friend friend)
{
this.friend = friend;
}
@Override
public void setSession(Map<String, Object>
session) {
// TODO Auto-generated method
stub
this.session =
session;
}
@Override
public Object getModel() {
// TODO
Auto-generated method stub
friend = new
Friend();
return friend;
}
FriendService fser =
ServiceFactory.getFriendServieInstance();
//查看所属档案的常用联系人
public
String selectfriendlist()throws Exception
{
Profile
profile = (Profile)session.get("profile");
List list =
null;
try{
list =
fser.byprofileid(profile.getProfileid());
}catch(Exception
e){
e.printStackTrace();
}
//
没有紧急联系人，就添加
session.put("friendlist",
list);
request.put("tabletype",
"friendlist");
request.put("sjtabletype",
"sjfriendlist");
request.put("pagination",
"");
return
SUCCESS;
}
//导出所属档案的常用联系人为excel
public
String exportFriend() throws Exception{
HSSFWorkbook hssfworkbook
= new HSSFWorkbook();
HSSFSheet hssfsheet =
hssfworkbook.createSheet();
HSSFRow hssfrow =
hssfsheet.createRow(0);
//定义表头
hssfrow.createCell((short)0).setCellValue("姓名");
hssfrow.createCell((short)1).setCellValue("性别");
hssfrow.createCell((short)2).setCellValue("所属关系");
hssfrow.createCell((short)3).setCellValue("手机号码");
hssfrow.createCell((short)4).setCellValue("电子邮件");
Profile
profile = (Profile)session.get("profile");
int i =
1;
Iterator it
= fser.byprofileid(profile.getProfileid()).iterator(); //根据档案id查看他所有的常用联系人，并迭代
//添加表内容
while
(it.hasNext()) {
Friend friend = (Friend)
it.next();
hssfrow =
hssfsheet.createRow(i);
hssfrow.createCell((short)0).setCellValue(friend.getFname());
hssfrow.createCell((short)1).setCellValue(friend.getFgender());
hssfrow.createCell((short)2).setCellValue(friend.getFrelationship());
hssfrow.createCell((short)3).setCellValue(friend.getFmobilephone());
hssfrow.createCell((short)4).setCellValue(friend.getFemail());
i++;
}
FileOutputStream
fileoutputstream = null;
try
{
// fileoutputstream = new
FileOutputStream("d:\Friend.xls");
// hssfworkbook.write(fileoutputstream);
// fileoutputstream.close();
this.fileName
= "friend";
ByteArrayOutputStream baos =
new
ByteArrayOutputStream();
hssfworkbook.write(baos);
baos.flush();
byte[]
aa =
baos.toByteArray();
// String
filename =
"friend";
excelStream
= new ByteArrayInputStream(aa,0,
aa.length);
baos.close();
} catch (FileNotFoundException e) {
//
TODO Auto-generated catch
block
e.printStackTrace();
} catch
(IOException e) {
// TODO Auto-generated catch
block
e.printStackTrace();
e.printStackTrace();
}
return
SUCCESS;
}
@Override
public void
setRequest(Map<String, Object> request) {
// TODO
Auto-generated method stub
this.request = request;
}
}
2.struts内定义action
<!-- 导出常用联系人为excel -->
<action
name="exportFriend" class="com.szallway.phr2.portal.action.FriendAction"
method="exportFriend">
<!-- <result
name="success"
type="redirectAction">selectfriendlist</result> -->
<result
name="success"
type="stream">
<!--
文件类型 -->
<param
name="contentType">
application/vnd.ms-excel</param>
<!--
excelStream 与对应action中的输入流的名字要一致
-->
<param name=
" inputName">
excelStream</param>
<!--
文件名 与action中fileName一致
-->
<param
name="contentDisposition">attachment;filename="
${fileName}.xls"</param>
</result>
</action>
3.jsp页面
在jsp页面只需加入<a href="exportFriend.action">导出excel</a>这样一连接或者表单按钮
<form action="exportFriend.action" method="post"><input type="submit" value="导出excel"/></from>
4.效果图
http://blog.sina.com.cn/s/blog_8394b21401012zbk.html
[转载]poi导出excel,可以自定义保存路径,布布扣,bubuko.com
原文：http://www.cnblogs.com/luyesql/p/3594052.html