Implement Word, Excel format report printing with JSP

Title: Using JSP to implement Word, Excel format report print

Author: Evan

Date: 2003-08-21

Because MS Word and Excel support HTML text format, you can use Word or Excel to do a template, save it as a web page, and then change the HTML to JSP, you can dynamically fill the data part, you don't have to worry hard. Adjustment format

Word page As long as the JSP head is set as follows:

<% @ Page ContentType = "Application / Msword; Charset = GBK"%>

Excel is as follows:

<% @ Page ContentType = "Application / VND.MS-Excel; Charset = GBK"%>

Using this method The client must have Office software installed, and the user will open this page directly in IE when the user is accessible.

This method advantage is that template design, convenient adjustment, no need to use complex POI or JXL technology on server-side, there is no need to use ActiveX control technology, safer, more secure, and easy to implement better printing effects on the client.

Microsoft About Server Dynamically Create Information of Office Documents (ASP Example):

http://support.microsoft.com/default.aspx?scid=kb;n-us;301044&

Simple example:

Use Word to create a document, draw forms as follows:

----------------------------

| Username | Real Name | Gender |

----------------------------

| GUEST | Passenger | Male |

----------------------------

Saved as the web page test.htm, renamed.htm to Test.jsp, modify it

Guest, passerby, male is dynamically inquiry from the database, as follows:

<% @ Page ContentType = "Application / Msword; Charset = GBK"%>

<% @ Page Import = "java.sql. *"%>

XMLns: w = "URN: Schemas-Microsoft-Com: Office: WORD"

XMLns = "http://www.w3.org/tr/rec-html40">