jsp提供excel下载

最新推荐文章于 2023-02-07 16:13:28 发布

hjay0715

最新推荐文章于 2023-02-07 16:13:28 发布

阅读量759

点赞数

分类专栏： j2ee相关文章标签： excel jsp import output exception string

本文链接：https://blog.youkuaiyun.com/hjay0715/article/details/6069759

版权

j2ee相关专栏收录该内容

6 篇文章

订阅专栏

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" contentType="application/x-msexcel"%>
<%@ page import="java.text.*" %>
<%@ page import="java.text.DecimalFormat" %>
<%@ page import="java.io.*"%>
<%@ page import="org.apache.poi.hssf.usermodel.*"%>
<%@ page import="javax.servlet.ServletOutputStream"%>
<html>
<head>
    <title>企业所得税月（季）度预缴纳税申报表（A类）导出</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
</head>
<body>
<%

FileInputStream input = new FileInputStream("C:/test.xls");
HSSFWorkbook workbook = new HSSFWorkbook(input);
HSSFSheet sheet = workbook.getSheetAt(0);
HSSFRow row = sheet.getRow(2);
HSSFCell cell = row.getCell((short)1);
cell.setCellValue("dfsd");
row = sheet.getRow(3);
cell = row.getCell((short)1);
cell.setCellValue("1111111");
row = sheet.getRow(4);
cell = row.getCell((short)1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);//设置字符集
cell.setCellValue("中文");
ServletOutputStream output= null;
response.reset();//不加的话可能会乱码
response.setContentType("application/x-msexcel;charset=UTF-8");
String fileName = "test";
     String codedFileName = java.net.URLEncoder.encode(fileName, "UTF-8");
     response.setHeader("content-disposition", "attachment; filename=/""+codedFileName+".xls");
try{
output = response.getOutputStream();
workbook.write(output);
output.flush();
}catch(Exception e){

}finally{
   input.close();
   output.close();
}
%>
</body>
</html>