Home > Developer > JSP

Use JSP to print reports in Word and Excel formats

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞



Use JSP to print reports in Word and Excel formats

Http://www.javaresearch.org/article/showarticle.jsp? Column = 106 & Thread = 8444
Evan original (Participation score: 35753, expert score: 640) published: Update: Version: 1.0 read:9045Times



Title: use JSP to print reports in Word and Excel formats

Author: Evan

Email: evan_zhao@hotmail.com

Date: 2003-08-21

Because documents in MS Word and Excel support HTML text format, you can use Word or Excel to make a template, save it as a Web page, change the HTML to JSP, and enter the data part dynamically, no need to adjust the format

 

On the word page, you only need to set the following commands in the JSP header:

<% @ Page contenttype = "application/MSWord; charset = GBK" %>

 

Excel is as follows:

<% @ Page contenttype = "application/vnd. MS-Excel; charset = GBK" %>

In this way, the client must have the office software installed. When you access the client, you can directly open the page in word or excel in IE.

The advantage of this method is that it is easy to design and adjust templates. You do not need to use complicated poi or jxl technology on the server side, or use ActiveX Control Technology on the client side, which is safer and more convenient, easy to achieve better printing results.

Microsoft documents on Dynamically creating an office on the server (ASP example ):

Http://support.microsoft.com/default.aspx? SCID = KB; en-US; 301044 &

 

Simple Example:

Use Word to create a document, as shown in the following table:

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

| User name | real name | gender |

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

| Guest | passer-by | male |

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

Save it as webpage test.htm, change test.htm to test. jsp, and modifyGuest, Lu renjia, maleFor dynamic queries from the database, as follows:

  4. <% @ Page contenttype = "application/MSWord; charset = GBK" %>
  6. <% @ PageImport= "Java. SQL. *" %>
  8. <HTML xmlns: O = "urn: Schemas-Microsoft-com: Office: office"
  10. Xmlns: W = "urn: Schemas-Microsoft-com: Office: Word"
  12. Xmlns = "http://www.w3.org/TR/REC-html40">
  16. <Head>
  18. <Meta http-equiv = Content-Type content = "text/html; charset = gb2312">
  20. <Meta name = progid content = word. Document>
  22. <Meta name = generator content = "Microsoft Word 9">
  24. <Meta name = originator content = "Microsoft Word 9">
  26. <Title> User Information </title>
  28. <! --[IfGte mso 9]> <XML>
  30. <O: documentproperties>
  32. <O: Author> Evan Zhao </O: Author>
  34. <O: lastauthor> Evan Zhao </O: lastauthor>
  36. <O: Revision> 1 </O: Revision>
  38. <O: totaltime> 1 </O: totaltime>
  40. <O: created> 2003-08-20t16: 26: 00Z </O: created>
  42. <O: lastsaved> 2003-08-20t16: 27: 00Z </O: lastsaved>
  44. <O: pages> 1 </O: pages>
  46. <O: Company> Taiping </O: Company>
  48. <O: lines> 1 </O: lines>
  50. <O: paragraphs> 1 </O: paragraphs>
  52. <O: version> 9.2812 </O: version>
  54. </O: documentproperties>
  56. </XML> <! [Endif] --> <! --[IfGte mso 9]> <XML>
  58. <W: worddocument>
  60. <W: punctuationkerning>
  62. <W: drawinggridverticalspacing> 7.8 lbs </W: drawinggridverticalspacing>
  64. <W: displayhorizontaldrawinggridevery> 0 </W: displayhorizontaldrawinggridevery>
  66. <W: displayverticaldrawinggridevery> 2 </W: displayverticaldrawinggridevery>
  68. <W: Compatibility>
  70. <W: spaceforul>
  72. <W: balancesinglebytedoublebytewidth>
  74. <W: donotleavebackslashalone>
  76. <W: ultrailspace>
  78. <W: donotexpandshiftreturn>
  80. <W: adjustlineheightintable>
  82. <W: usefelayout>
  84. </W: Compatibility>
  86. </W: worddocument>
  88. </XML> <! [Endif] -->
  90. <Style>
  92. <! --
  94.  /* Font Definitions */
  96. @ Font-face
  98. {Font-family:;
  100. Panose-1: 2 1 6 0 3 1 1 1 1 1;
  102. MSO-font-alt: simsun;
  104. MSO-font-charset: 134;
  106. MSO-generic-font-family: auto;
  108. MSO-font-pitch: variable;
  110. MSO-font-Signature: 3 135135232 16 0 262145 0 ;}
  112. @ Font-face
  114. {Font-family: "\ @ ";
  116. Panose-1: 2 1 6 0 3 1 1 1 1 1;
  118. MSO-font-charset: 134;
  120. MSO-generic-font-family: auto;
  122. MSO-font-pitch: variable;
  124. MSO-font-Signature: 3 135135232 16 0 262145 0 ;}
  126.  /* Style definitions */
  128. P. msonormal, Li. msonormal, Div. msonormal
  130. {MSO-style-parent :"";
  132. Margin: 0 cm;
  134. Margin-bottom:. 0001pt;
  136. Text-align: justify;
  138. Text-justify: Inter-ideograph;
  140. MSO-pagination: none;
  142. Font-size: 10.5pt;
  144. MSO-bidi-font-size: 12.0pt;
  146. Font-family: "Times New Roman ";
  148. MSO-Fareast-font-family:;
  150. MSO-font-kerning: 1.0pt ;}
  152.  /* Page Definitions */
  154. @ Page
  156. {MSO-page-border-Surround-header: No;
  158. MSO-page-border-Surround-footer: No ;}
  160. @ Page Section1
  162. {Size: 595.3pt 841.9pt;
  164. Margin: 72.0pt 90.0pt 72.0pt 90.0pt;
  166. MSO-header-margin: 42.55pt;
  168. MSO-footer-margin: 49.6pt;
  170. MSO-paper-Source: 0;
  172. Layout-grid: 15.6pt ;}
  174. Div. Section1
  176. {Page: Section1 ;}
  178. -->
  180. </Style>
  182. </Head>
  186. <Body lang = ZH-CN style = 'tab-interval: 21.0pt; text-justify-Trim: punctuation '>
  190. <DivClass= Section1 style = 'layout-grid: 15.6pt '>
  196. <Table border = 1 cellspacing = 0 cellpadding = 0 style = 'border-collapse: collapse;
  198. Border: none; MSO-border-alt: solid windowtext. 5pt; MSO-padding-alt: 0 cm 5.4pt 0 cm 5.4pt '>
  200. <Tr>
  202. <TD width = 189 valign = top style = 'width: 142.0pt; Border: solid windowtext. 5pt;
  204. Padding: 0 cm 5.4pt 0 cm 5.4pt '>
  206. <PClass= Msonormal> <span style = 'font-family:; MSO-ascii-font-family: "Times New Roman ";
  208. MSO-Hansi-font-family: "Times New Roman" '> User Name </span> </P>
  210. </TD>
  212. <TD width = 189 valign = top style = 'width: 142.05pt; Border: solid windowtext. 5pt;
  214. Border-left: none; MSO-border-left-alt: solid windowtext. 5pt; padding: 0 cm 5.4pt 0 cm 5.4pt '>
  216. <PClass= Msonormal> <span style = 'font-family:; MSO-ascii-font-family: "Times New Roman ";
  218. MSO-Hansi-font-family: "Times New Roman" '> real name </span> </P>
  220. </TD>
  222. <TD width = 189 valign = top style = 'width: 142.05pt; Border: solid windowtext. 5pt;
  224. Border-left: none; MSO-border-left-alt: solid windowtext. 5pt; padding: 0 cm 5.4pt 0 cm 5.4pt '>
  226. <PClass= Msonormal> <span style = 'font-family:; MSO-ascii-font-family: "Times New Roman ";
  228. MSO-Hansi-font-family: "Times New Roman" '> gender </span> </P>
  230. </TD>
  232. </Tr>
  234. <%
  236. Class. Forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
  240. StringUrl = "JDBC: ODBC: mydb ";
  244. // Connect to the mydb Database
  246. Connection con = drivermanager. getconnection (URL ,"","");
  250. Try{
  252. Statement stmt = con. createstatement ();
  256. // Query the employee table
  258. Resultset rs1_stmt.exe cutequery ("select user_name, real_name, gender from employee ");
  262. While(Rs. Next ()){
  264. %>
  268. <Tr>
  270. <TD width = 189 valign = top style = 'width: 142.0pt; Border: solid windowtext. 5pt;
  272. Border-top: none; MSO-border-top-alt: solid windowtext. 5pt; padding: 0 cm 5.4pt 0 cm 5.4pt '>
  274. <PClass= Msonormal> <SPAN lang = en-US> <% = Rs. getstring ("user_name") %> </span> </P>
  276. </TD>
  278. <TD width = 189 valign = top style = 'width: 142.05pt; border-top: none; border-left:
  280. None; border-bottom: solid windowtext. 5pt; border-Right: solid windowtext. 5pt;
  282. MSO-border-top-alt: solid windowtext. 5pt; MSO-border-left-alt: solid windowtext. 5pt;
  284. Padding: 0 cm 5.4pt 0 cm 5.4pt '>
  286. <PClass= Msonormal> <span style = 'font-family:; MSO-ascii-font-family: "Times New Roman ";
  288. MSO-Hansi-font-family: "Times New Roman" '> <% = Rs. getstring ("real_name") %> </span> </P>
  290. </TD>
  292. <TD width = 189 valign = top style = 'width: 142.05pt; border-top: none; border-left:
  294. None; border-bottom: solid windowtext. 5pt; border-Right: solid windowtext. 5pt;
  296. MSO-border-top-alt: solid windowtext. 5pt; MSO-border-left-alt: solid windowtext. 5pt;
  298. Padding: 0 cm 5.4pt 0 cm 5.4pt '>
  300. <PClass= Msonormal> <span style = 'font-family:; MSO-ascii-font-family: "Times New Roman ";
  302. MSO-Hansi-font-family: "Times New Roman" '> <% = Rs. getstring ("gender") %> </span> </P>
  304. </TD>
  306. </Tr>
  310. <%
  312. }// End while
  316. Rs. Close ();
  318. Stmt. Close ();
  320. }Finally{
  322. Con. Close ();
  324. }
  326. %>
  330. </Table>
  334. <PClass= Msonormal> <SPAN lang = en-US> <! [If! Supportemptyparas]> <! [Endif]> <O: P> </span> </P>
  338. </Div>
  342. </Body>
  346. </Html>

Related links:

In good J2EEProgramThe database query may be written in a special Dao (Data Access Object). For how to conveniently query data and pass the list to the JSP page, see:

Common JSP page query display modes

Reference: how to print reports in Web Applications

Copyright Notice to the author
This article ArticleIs it helpful to you? Vote: Yes NoVoting Result: 2 0
Other articles by the author:

  • JSP paging technology implementation
  • Common JSP page query display modes

Author all articles

reviewer: tangzh score: 6 Expert score: 0 published on:
let's talk about your feelings:
I feel no value in using this method to print reports, for example: the special symbols (diagonal bars) in the table cannot be processed, the pages cannot be automated, and the header at the end of each page cannot be automatically added...
however, if you print a report in PDF format, the advantages of the report can be displayed.
reviewer: fetchpro score: 15 expert score: 0 published on:
agree with the upstairs comments! Word is not suitable for report generation.
I use the org.faceless.pdf software package to make PDF reports and use the Adobe Reader function.

COMMENTATOR: Evan score: 35753 expert score: 640 from: Shanghai
published at, December 3,
This is a simple solution and is suitable for lightweight applications without table-preserving tools. In word, you can use the header and footer, or use a paging character to control pages. Formulas can be embedded in Excel to facilitate operations by business departments, in addition, users can re-process this result
the biggest problem with PDF printing is how to design the page layout and font, if you have a convenient visual editor for template creation,

if you want to make professional reports, you still need professional table maintenance tools, various file formats can be easily generated

comments: wanglaobie score: 9 expert score: 0 published on:
in this way, the report is deformed. Is there any way to output the report to word without deformation?

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
how to use print r in php how to use percentile function in excel how to use word wrap in css how to use ceiling function in excel how to use percentile in excel excel dashboards and reports 2nd edition pdf how to automate excel reports using macros
Related Article
JSP (6)--JSP declaration
Springboot load JSP refresh JSP, refresh controller (try it Y...
Javax.servlet.jsp.PageContext cannot is resolved to a type
A simple calculator for JSP exercises (using Jsp+javabean mode)
Use absolute path $ {pagecontext. Request. contextpath} in JSP}

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More