用html格式导出excel

来源：互联网发布：知言养气编辑：程序博客网时间：2024/05/17 21:57
<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@page import="java.util.Calendar"%><%response.setCharacterEncoding("UTF-8");response.setContentType("application/vnd.ms-excel");  response.setHeader("Content-Disposition", "attachment;filename=\""+ String.format("%1$tY%1$tm%1$td%1$tH%1$tM%1$tS%1$tL", Calendar.getInstance()) + ".xls\"");   %><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>导出Excel</title></head><body><table width="100%" cellpadding="0" cellspacing="0" border="1"><thead><tr><th>监测点</th><th>AQI<br>空气质量指数</th><th>空气质量<br>指数类别</th><th>PM2.5<br>细颗粒物</th><th>PM10<br>可吸入颗粒物</th><th>CO<br>一氧化碳</th><th>NO2<br>二氧化氮</th><th>O3<br>臭氧</th><th>SO2<br>二氧化硫</th></tr></thead><tbody><tr><td>大学城</td><td>67</td><td>良</td><td>19</td><td>0</td><td>1.439</td><td>11</td><td>63</td><td>14</td></tr><tr><td><img style="margin-top:50px;" src="http://127.0.0.1:8080/wsn_aqi/image/zhanweichart.png"/></td></tr></tbody></table></body></html>