至尊神魔:在JSP中通过http协议生成excel和word

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

MIME介绍：

MIME 类型

MIME (Multipurpose Internet Mail Extensions) 是描述消息内容类型的因特网标准。

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-stream323text/h323acxapplication/internet-property-streamaiapplication/postscriptaifaudio/x-aiffaifcaudio/x-aiffaiffaudio/x-aiffasfvideo/x-ms-asfasrvideo/x-ms-asfasxvideo/x-ms-asfauaudio/basicavivideo/x-msvideoaxsapplication/olescriptbastext/plainbcpioapplication/x-bcpiobinapplication/octet-streambmpimage/bmpctext/plaincatapplication/vnd.ms-pkiseccatcdfapplication/x-cdfcerapplication/x-x509-ca-certclassapplication/octet-streamclpapplication/x-msclipcmximage/x-cmxcodimage/cis-codcpioapplication/x-cpiocrdapplication/x-mscardfilecrlapplication/pkix-crlcrtapplication/x-x509-ca-certcshapplication/x-cshcsstext/cssdcrapplication/x-directorderapplication/x-x509-ca-certdirapplication/x-directordllapplication/x-msdownloaddmsapplication/octet-streamdocapplication/msworddotapplication/msworddviapplication/x-dvidxrapplication/x-directorepsapplication/postscriptetxtext/x-setextevyapplication/envoyexeapplication/octet-streamfifapplication/fractalsflrx-world/x-vrmlgifimage/gifgtarapplication/x-gtargzapplication/x-gziphtext/plainhdfapplication/x-hdfhlpapplication/winhlphqxapplication/mac-binhex40htaapplication/htahtctext/x-componenthtmtext/htmlhtmltext/htmlhtttext/webviewhtmlicoimage/x-iconiefimage/iefiiiapplication/x-iphoneinsapplication/x-internet-signupispapplication/x-internet-signupjfifimage/pipegjpeimage/jpegjpegimage/jpegjpgimage/jpegjsapplication/x-javascriptlatexapplication/x-latexlhaapplication/octet-streamlsfvideo/x-la-asflsxvideo/x-la-asflzhapplication/octet-streamm13application/x-msmediaviewm14application/x-msmediaviewm3uaudio/x-mpegurlmanapplication/x-troff-manmdbapplication/x-msaccessmeapplication/x-troff-memhtmessage/rfc822mhtmlmessage/rfc822midaudio/midmnyapplication/x-msmoneymovvideo/quicktimemovievideo/x-sgi-moviemp2video/mpegmp3audio/mpegmpavideo/mpegmpevideo/mpegmpegvideo/mpegmpgvideo/mpegmppapplication/vnd.ms-projectmpv2video/mpegmsapplication/x-troff-msmvbapplication/x-msmediaviewnwsmessage/rfc822odaapplication/odap10application/pkcs10p12application/x-pkcs12p7bapplication/x-pkcs7-certificatesp7capplication/x-pkcs7-mimep7mapplication/x-pkcs7-mimep7rapplication/x-pkcs7-certreqrespp7sapplication/x-pkcs7-signaturepbmimage/x-portable-bitmappdfapplication/pdfpfxapplication/x-pkcs12pgmimage/x-portable-graymappkoapplication/ynd.ms-pkipkopmaapplication/x-perfmonpmcapplication/x-perfmonpmlapplication/x-perfmonpmrapplication/x-perfmonpmwapplication/x-perfmonpnmimage/x-portable-anymappot,application/vnd.ms-powerpointppmimage/x-portable-pixmapppsapplication/vnd.ms-powerpointpptapplication/vnd.ms-powerpointprfapplication/pics-rulespsapplication/postscriptpubapplication/x-mspublisherqtvideo/quicktimeraaudio/x-pn-realaudioramaudio/x-pn-realaudiorasimage/x-cmu-rasterrgbimage/x-rgbrmiaudio/midroffapplication/x-troffrtfapplication/rtfrtxtext/richtextscdapplication/x-msschedulescttext/scriptletsetpayapplication/set-payment-initiationsetregapplication/set-registration-initiationshapplication/x-shsharapplication/x-sharsitapplication/x-stuffitsndaudio/basicspcapplication/x-pkcs7-certificatessplapplication/futuresplashsrcapplication/x-wais-sourcesstapplication/vnd.ms-pkicertstorestlapplication/vnd.ms-pkistlstmtext/htmlsvgimage/svg+xmlsv4cpioapplication/x-sv4cpiosv4crcapplication/x-sv4crcswfapplication/x-shockwave-flashtapplication/x-trofftarapplication/x-tartclapplication/x-tcltexapplication/x-textexiapplication/x-texinfotexinfoapplication/x-texinfotgzapplication/x-compressedtifimage/tifftiffimage/tifftrapplication/x-trofftrmapplication/x-msterminaltsvtext/tab-separated-valuestxttext/plainulstext/iulsustarapplication/x-ustarvcftext/x-vcardvrmlx-world/x-vrmlwavaudio/x-wavwcmapplication/vnd.ms-workswdbapplication/vnd.ms-workswksapplication/vnd.ms-workswmfapplication/x-msmetafilewpsapplication/vnd.ms-workswriapplication/x-mswritewrlx-world/x-vrmlwrzx-world/x-vrmlxafx-world/x-vrmlxbmimage/x-xbitmapxlaapplication/vnd.ms-excelxlcapplication/vnd.ms-excelxlmapplication/vnd.ms-excelxlsapplication/vnd.ms-excelxltapplication/vnd.ms-excelxlwapplication/vnd.ms-excelxofx-world/x-vrmlxpmimage/x-xpixmapxwdimage/x-xwindowdumpzapplication/x-compresszipapplication/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");//下载方式
%>

 

   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   


   
   
   
   
   
   
   
   

项目	费用					考核2
项目1	1
	2
	31	32
	41	42
	51	52
项目2
合计