1,在JSP页面中加入如下内容
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<%response.setHeader("Content-disposition","attachment;filename=operrpt.xls");%>
具体的安放位置可以放在<head></head>之后;
2,在<body></body>内出现的内容都会被放到生成的EXCEL文件中;
3,测试下:将以下内容存成一个excel.jsp文件,放到服务器上,然后在浏览器内输入访问地址即可
<html>
<head>
<title>Excel文档</title>
</head>
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<%response.setHeader("Content-disposition","attachment;filename=operrpt.xls");%>
<body>
这是测试内容,查看是否能够写入到生成的EXCEL文件中!
</body>
</html>
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<%response.setHeader("Content-disposition","attachment;filename=operrpt.xls");%>
具体的安放位置可以放在<head></head>之后;
2,在<body></body>内出现的内容都会被放到生成的EXCEL文件中;
3,测试下:将以下内容存成一个excel.jsp文件,放到服务器上,然后在浏览器内输入访问地址即可
<html>
<head>
<title>Excel文档</title>
</head>
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<%response.setHeader("Content-disposition","attachment;filename=operrpt.xls");%>
<body>
这是测试内容,查看是否能够写入到生成的EXCEL文件中!
</body>
</html>