java文件下载

最新推荐文章于 2023-12-12 08:56:02 发布

to_Date32

最新推荐文章于 2023-12-12 08:56:02 发布

阅读量290

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/to_date32/article/details/78190940

版权

java 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

html：

<a  href="javascript:;" type='button'  οnclick="importExcel()">数据导出</a>

js：

function importExcel(){
     var url = '';

     var form = $("<form></form>").attr("action", url).attr("method", "post");
     form.append($("<input></input>").attr("type", "hidden").attr("name", "duration").attr("value", test));
     form.appendTo('body').submit().remove();
}

java:

/**
	 * 输出文件
	 * 
	 * @param response
	 * @throws IOException
	 */
	protected static void print(HttpServletResponse response, HSSFWorkbook workbook) throws IOException {
		String fileNameGb = new String(fileName.getBytes("gb2312"), "ISO8859-1");
		ByteArrayOutputStream baos = new ByteArrayOutputStream();
		workbook.setSelectedTab(0);
		workbook.write(baos);
		response.setContentType("application/x-download;charset=utf-8");
		response.addHeader("Content-Disposition", "attachment;filename=" + fileNameGb + ".xls");
		OutputStream os = response.getOutputStream();
		ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
		byte[] b = new byte[1024];
		while ((bais.read(b)) > 0) {
			os.write(b);
		}
		bais.close();
		os.flush();
		os.close();
	}

拼接excel数据就不贴出来了。