在JSP中通过http协议生成excel和word



在 JSP页面中可以通过设置MIME类型，来实现将WEB页面变为WORD和EXCEL，以前我是通过jxl.jar这个包来实现导出EXCEL，用 jxl.jar虽然比较方便简单，但如果一个系统需要大量的导出EXCEL，那么用jxl导出就要写很多个方法，这个工作量巨大，我以前就在一个项目中为 这个写了20个多导出，写的头都大了。现在可以设置MIME类型来实现，再也不用写大量的jxl代码了，哈哈，真是我的救星哇。

MIME介绍：

MIME 类型

MIME (M ultipurpose I nternet M ail E xtensions) 是描述消息内容类型的因特网标准。

MIME 消息能包含文本、图像、音频、视频以及其他应用程序专用的数据。

官方的 MIME 信息是由 Internet Engineering Task Force (IETF) 在下面的文档中提供的：

• RFC-822 Standard for ARPA Internet text messages
• RFC-2045 MIME Part 1: Format of Internet Message Bodies
• RFC-2046 MIME Part 2: Media Types
• RFC-2047 MIME Part 3: Header Extensions for Non-ASCII Text
• RFC-2048 MIME Part 4: Registration Procedures
• RFC-2049 MIME Part 5: Conformance Criteria and Examples

不同的应用程序支持不同的 MIME 类型。

下面的参考手册是由 Microsoft Internet Information Server version 5 所支持的 MIMEI 类型列表。

按照文件扩展名排列的 Mime 类型列表

扩展名	类型/子类型
*	application/octet-stream
323	text/h323
acx	application/internet-property-stream
ai	application/postscript
aif	audio/x-aiff
aifc	audio/x-aiff
aiff	audio/x-aiff
asf	video/x-ms-asf
asr	video/x-ms-asf
asx	video/x-ms-asf
au	audio/basic
avi	video/x-msvideo
axs	application/olescript
bas	text/plain
bcpio	application/x-bcpio
bin	application/octet-stream
bmp	image/bmp
c	text/plain
cat	application/vnd.ms-pkiseccat
cdf	application/x-cdf
cer	application/x-x509-ca-cert
class	application/octet-stream
clp	application/x-msclip
cmx	image/x-cmx
cod	image/cis-cod
cpio	application/x-cpio
crd	application/x-mscardfile
crl	application/pkix-crl
crt	application/x-x509-ca-cert
csh	application/x-csh
css	text/css
dcr	application/x-director
der	application/x-x509-ca-cert
dir	application/x-director
dll	application/x-msdownload
dms	application/octet-stream
doc	application/msword
dot	application/msword
dvi	application/x-dvi
dxr	application/x-director
eps	application/postscript
etx	text/x-setext
evy	application/envoy
exe	application/octet-stream
fif	application/fractals
flr	x-world/x-vrml
gif	image/gif
gtar	application/x-gtar
gz	application/x-gzip
h	text/plain
hdf	application/x-hdf
hlp	application/winhlp
hqx	application/mac-binhex40
hta	application/hta
htc	text/x-component
htm	text/html
html	text/html
htt	text/webviewhtml
ico	image/x-icon
ief	image/ief
iii	application/x-iphone
ins	application/x-internet-signup
isp	application/x-internet-signup
jfif	image/pipeg
jpe	image/jpeg
jpeg	image/jpeg
jpg	image/jpeg
js	application/x-javascript
latex	application/x-latex
lha	application/octet-stream
lsf	video/x-la-asf
lsx	video/x-la-asf
lzh	application/octet-stream
m13	application/x-msmediaview
m14	application/x-msmediaview
m3u	audio/x-mpegurl
man	application/x-troff-man
mdb	application/x-msaccess
me	application/x-troff-me
mht	message/rfc822
mhtml	message/rfc822
mid	audio/mid
mny	application/x-msmoney
mov	video/quicktime
movie	video/x-sgi-movie
mp2	video/mpeg
mp3	audio/mpeg
mpa	video/mpeg
mpe	video/mpeg
mpeg	video/mpeg
mpg	video/mpeg
mpp	application/vnd.ms-project
mpv2	video/mpeg
ms	application/x-troff-ms
mvb	application/x-msmediaview
nws	message/rfc822
oda	application/oda
p10	application/pkcs10
p12	application/x-pkcs12
p7b	application/x-pkcs7-certificates
p7c	application/x-pkcs7-mime
p7m	application/x-pkcs7-mime
p7r	application/x-pkcs7-certreqresp
p7s	application/x-pkcs7-signature
pbm	image/x-portable-bitmap
pdf	application/pdf
pfx	application/x-pkcs12
pgm	image/x-portable-graymap
pko	application/ynd.ms-pkipko
pma	application/x-perfmon
pmc	application/x-perfmon
pml	application/x-perfmon
pmr	application/x-perfmon
pmw	application/x-perfmon
pnm	image/x-portable-anymap
pot,	application/vnd.ms-powerpoint
ppm	image/x-portable-pixmap
pps	application/vnd.ms-powerpoint
ppt	application/vnd.ms-powerpoint
prf	application/pics-rules
ps	application/postscript
pub	application/x-mspublisher
qt	video/quicktime
ra	audio/x-pn-realaudio
ram	audio/x-pn-realaudio
ras	image/x-cmu-raster
rgb	image/x-rgb
rmi	audio/mid
roff	application/x-troff
rtf	application/rtf
rtx	text/richtext
scd	application/x-msschedule
sct	text/scriptlet
setpay	application/set-payment-initiation
setreg	application/set-registration-initiation
sh	application/x-sh
shar	application/x-shar
sit	application/x-stuffit
snd	audio/basic
spc	application/x-pkcs7-certificates
spl	application/futuresplash
src	application/x-wais-source
sst	application/vnd.ms-pkicertstore
stl	application/vnd.ms-pkistl
stm	text/html
svg	image/svg+xml
sv4cpio	application/x-sv4cpio
sv4crc	application/x-sv4crc
swf	application/x-shockwave-flash
t	application/x-troff
tar	application/x-tar
tcl	application/x-tcl
tex	application/x-tex
texi	application/x-texinfo
texinfo	application/x-texinfo
tgz	application/x-compressed
tif	image/tiff
tiff	image/tiff
tr	application/x-troff
trm	application/x-msterminal
tsv	text/tab-separated-values
txt	text/plain
uls	text/iuls
ustar	application/x-ustar
vcf	text/x-vcard
vrml	x-world/x-vrml
wav	audio/x-wav
wcm	application/vnd.ms-works
wdb	application/vnd.ms-works
wks	application/vnd.ms-works
wmf	application/x-msmetafile
wps	application/vnd.ms-works
wri	application/x-mswrite
wrl	x-world/x-vrml
wrz	x-world/x-vrml
xaf	x-world/x-vrml
xbm	image/x-xbitmap
xla	application/vnd.ms-excel
xlc	application/vnd.ms-excel
xlm	application/vnd.ms-excel
xls	application/vnd.ms-excel
xlt	application/vnd.ms-excel
xlw	application/vnd.ms-excel
xof	x-world/x-vrml
xpm	image/x-xpixmap
xwd	image/x-xwindowdump
z	application/x-compress
zip	application/zip

示例代码：

<%--
contentType="application/msword;charset=GBK",这是设置页面为WORD格式
<%@ page language="java" contentType="application/msword;charset=GBK" %>
 --%>
 <%-- contentType="application/vnd.ms-excel;charset=GBK",这是设置页面为EXCEL格式 --%>
 <%@ page language="java" contentType="application/vnd.ms-excel;charset=GBK" %>
 <%
 response.setHeader("Content-disposition","inline; filename=excel.xls");//线上浏览方式
//response.setHeader("Content-disposition","attachment; filename=excel.xls");//下载方式
%>
 <html>
 <head> 
 <title></title>
 </head>

<body>
 <table width="100%" border="1">
 <tr>
     <td align="center" valign="middle">项目</td>
     <td colspan="5" align="center" valign="middle">费用</td>
     <td colspan="2" align="center" valign="middle">考核2</td>
 </tr>
 <tr>
     <td rowspan="5" align="center" valign="middle">项目1</td>
     <td colspan="2" align="center" valign="middle">1</td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td colspan="2" align="center" valign="middle">2</td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle">31</td>
     <td align="center" valign="middle">32</td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle">41</td>
     <td align="center" valign="middle">42</td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle">51</td>
     <td align="center" valign="middle">52</td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td rowspan="8" align="center" valign="middle">项目2</td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 <tr>
     <td align="center" valign="middle">合计</td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
     <td align="center" valign="middle"> </td>
 </tr>
 </table>
 </body>
 </html>