我的资源里有个 java 解析 excel 源码,还有个 excel 文件导入数据库源码,楼主去看看,参考下
解决方案 »
- JTA事务的奇怪异常。
- 跪求tokyocabinet.jar这个jar包
- 【求助】写了一个用RSA类似ICQ的通信加密程序中,公钥如何发送给服务器??
- 如何自动加载jar包?
- Spring2.0 + hibernate + struts问题
- 谁有webshere Application server
- 华为考试题.请个为帮忙!
- 有人从事JMS方面的程序设计吗?我有个问题请教!!!!!
- eclipse使用jdbc连接orcl报错ORA-12505
- 关于spring事务以及aop中事务回滚问题
- 菜鸟提问(如果不用EJB,tomcat可以运行JAVA EE 程序吗?)
- hibernate 级联保存问题
public ActionForward doOpenExcel(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response
){
try{
//创建导入格式表文件
OutputStream os=response.getOutputStream();
// 清空输出流
response.reset();
// 设置响应头和下载保存的文件名
response.setHeader("content-disposition",
"attachment;filename=bianyikaxinxi.xls");
// 定义输出类型
response.setContentType("APPLICATION/msexcel");
WritableWorkbook wwb=Workbook.createWorkbook(os);
WritableSheet ws =wwb.createSheet("编译卡信息",10);
// 设置部分列的宽度
ws.setColumnView(1, 20);
ws.setColumnView(2, 20);
ws.setColumnView(3, 20);
ws.setColumnView(4, 20);
ws.setColumnView(6, 35);
// 设置表头
ws.addCell(new Label(0,0,"卡号"));
ws.addCell(new Label(1,0,"卡型号"));
ws.addCell(new Label(2,0,"工种"));
ws.addCell(new Label(3,0,"姓名"));
ws.addCell(new Label(4,0,"班组"));
ws.addCell(new Label(5,0,"卡状态"));
ws.addCell(new Label(6,0,"注册时间"));
List list = (ArrayList)request.getSession().getAttribute("editCard_topPrint");
// 填充数据
if(list.size()>0){
for(int i=0;i<list.size();i++){
EditCardVO v= (EditCardVO)list.get(i);
ws.addCell(new Label(0,i+1,v.getCardid()));
ws.addCell(new Label(1,i+1,v.getCardmode()));
ws.addCell(new Label(2,i+1,v.getWorktype()));
ws.addCell(new Label(3,i+1,v.getName()));
ws.addCell(new Label(4,i+1,v.getGro()));
ws.addCell(new Label(5,i+1,v.getCardstate()));
ws.addCell(new Label(6,i+1,v.getRegdate()));
}
}
wwb.write();
wwb.close();
os.close();
}
catch(RowsExceededException e){
log.error("==编辑卡信息--导出excel==",e);
}
catch(WriteException ex){
log.error("==编辑卡信息--导出excel==",ex);
}
catch(IOException e){
log.error("==编辑卡信息--导出excel==",e);
}
return null;
}
jsp页面:<input type="button" value="导出excel" onclick="OpenExcel()">
function OpenExcel(){
window.parent.location.href="editcard.do?method=doOpenExcel";
return true;
}
response.setHeader("Cache-Control", "public");
response.setContentType("application/vnd.ms-excel;charset=UTF-8");
response.setHeader("Content-Disposition", "attachment; filename="
+ URLEncoder.encode("人员信息.xls", "UTF-8"));
OutputStream output = response.getOutputStream();
workBook = Workbook.createWorkbook(out);