JSP/servlet + poi export Excel

Address: http://zhanqi.net/blog/287/

Test Environment Servlet/struts2 + poi 3.7

Supports exporting the excel2003/2007 format, and the exported file name supports Chinese characters without garbled characters.

For more details, see the code and method annotations. For more information, see the poi download operation guide.

/**

* JSP/servlet + poi export Excel

*

*@ ParamResponse httpservletresponse

*@ ParamWB hssfworkbook/xssfworkbook

*@ ParamFilename xxx.xls (97-03)/xxx.xlsx (07-10)

*@ ThrowsIoexception

*/

Public Static VoidExportexcel (httpservletresponse response, workbook WB,

String filename)ThrowsIoexception {

// URL encoding is required if the file name is Chinese

Filename = urlencoder.Encode(Filename, "UTF-8 ");

Response. Reset ();

// Contenttype can be left unspecified

Response. setcontenttype ("application/vnd. MS-Excel; charset = UTF-8 ");

Response. setheader ("content-disposition", "attachment; filename =" + filename );

WB. Write (response. getoutputstream ());

Response. getoutputstream (). Flush ();

Response. getoutputstream (). Close ();

}