java如何将网页表格导出为excel

最新推荐文章于 2024-07-28 23:09:07 发布

S_壮

最新推荐文章于 2024-07-28 23:09:07 发布

阅读量2k

点赞数 1

分类专栏： Java 文章标签： java html 表单 excel maven

本文链接：https://blog.csdn.net/a1974117511/article/details/70282310

版权

Java 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

项目使用maven，导入依赖包

<!-- Table To Xls -->
<dependency>
    <groupId>me.chyxion</groupId>
    <artifactId>table-to-xls</artifactId>
    <version>0.0.1-RELEASE</version>
</dependency>

页面js构造表单，将html内容做为表单字段的值提交到后台

function exportExcel(){
	var html=$('.table').html();
	$('body').append('<form id="excelForm" action="'+basePath+'/file/downloadPage" method="post"><input type="text" id="excelContent" name="html" value=""/><input type="text" name="xlsName" value="导出文件名"/></form>');
	$('#excelContent').val(html);
	$('#excelForm').submit();
	$('#excelForm').remove();
}

后台

/**
 * 统计分析结果导出
 * @return
 * @throws UnsupportedEncodingException 
 */
@RequestMapping("/downloadPage")
public void downloadPage(String html,String xlsName,HttpServletResponse response,HttpServletRequest request) throws UnsupportedEncodingException{
	
	response.setContentType("application/vnd.ms-excel");
	response.setCharacterEncoding("utf-8");
	
	String agent = request.getHeader("USER-AGENT");  
       if(agent != null && agent.toLowerCase().indexOf("firefox") > 0){
           String downloadFileName = "=?UTF-8?B?" + (new String(Base64.encodeBase64(xlsName.getBytes("UTF-8"))+".xls")) + "?="; 
           response.setHeader("Content-Disposition", "attachment;filename=" + downloadFileName);
       }else{
       	response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(xlsName, "UTF-8")+".xls");  
       }
	
	try {
		ServletOutputStream out = response.getOutputStream();
		TableToXls.process(html, out);
		out.close();
	} catch (Exception e) {
		e.printStackTrace();
	}
}

搞定！！！