首先要导入 jxl 包。
然后在 jsp 页面写相应的代码。
显示导出数据按钮界面:
<script type="text/javascript">
function hpExport(obj){
obj.href = "pages/MKTADMIN_UNITCAP_LEVEL/excelExport.jsp";
return true;
}
<body>
<a href="#" id="hpExport" onClick="return hpExport(this)">导出数据</a>
</body>
导出界面代码如下:
<%@ page language="java"
import="java.util.*,java.io.*,jxl.write.WritableWorkbook,
jxl.Workbook,jxl.write.WritableSheet,jxl.write.Label,com.xz.tcps.acti
on.*,com.xz.tcps.service.*,com.xz.tcps.bean.*"
pageEncoding="UTF-8"%>
注意:导进自己对应的包名!如上所示
<body>
<%
response.setContentType("application/vnd.ms-excel"); //保证不乱码
String fileName="excel 表格数据.xls";
response.setHeader("Content-Disposition", "attachment;"+ "
filename="+ new String(fileName.getBytes(), "ISO-8859-1"));
OutputStream os = response.getOutputStream();
out.clear();
out = pageContext.pushBody();
WritableWorkbook book = Workbook.createWorkbook(os);
WritableSheet sheet = book.createSheet("导出的数据",0 );
MktAdmin_UnitCap_LevelService service = new
MktAdmin_UnitCap_LevelService();
List<MktAdmin_UnitCap_LevelBean> beans = service.QueryAlltcps();
for(int i=1;i<=3;i++)
{
评论6