It doesn�t irritate me at all. But you will get better help by asking on [EMAIL PROTECTED] There are about a dozen people who respond regularly to questions such as this, including the authors of the POI packages. They probably have better answers than I do.
However, people on the mail list may not respond to you directly (so you won �t necessarily get the answer via e-mail). A great way to learn POI would be to subscribe to the mail list (You will get about a half dozen messages per day.) To subscribe, just send a e-mail message to [EMAIL PROTECTED] You don�t need anything else in the message. Then you will begin to receive questions and answers by all the subscribers to the list. -----Original Message----- From: Terrence Lai Mun Tak [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:13 AM To: Michael Zalewski Subject: RE: jsp data into Excel HI Michael Thanks for the prompt reply! I apologise for pulling your name off the list, but it was the only button link available on the page that I was viewing. Sorry if it irritated you. I do have a big learning curve and I am fervently trying my utmost to close up the gap. Thanks for your help! Regards Terrence _____ From: Michael Zalewski [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:41 To: Terrence Lai Mun Tak Cc: POI Users List Subject: RE: jsp data into Excel You should ask questions on the list ([EMAIL PROTECTED]), instead of pulling individual people off the list. The simplest way to do what you ask is just to add the following near the top of your JSP page <% response.setContentType( �application/vnd-msexcel�); %> Then just make the web page contain a single table. You can apply most formatting styles, and you can use thead elements. The setContentType will make the page open in Excel. If you need more than a single sheet, or if you need something more complicated than a single table, you can use POI. You can even use POI for the simple case but the steps might be more complicated. If you are new to Java, you have a big learning curve. You might start with http://www.devx.com/Java/Article/17301? -----Original Message----- From: Terrence Lai Mun Tak [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:16 PM To: [EMAIL PROTECTED] Subject: RE: jsp data into Excel Hi Michael I found the thread which you replied to Srilatha dated 30 Dec 2003 on the export of HTML content from JSP to Excel. I am currently trying to do the same with a JSP form that will append information to an Excel file upon clicking on the Submit button. However, I am not familiar with the codes as to how to create the objects, and appending to the file (I am ASP-trained but the server we have is Unix, which is why I have to use JSP). Would appreciate it if you could guide me on this or direct me to a site where I can find the relevant code references that I require. Thanks in advance! Regards Terrence Lai Singapore
