>>>>> "hua" == hua ge <[EMAIL PROTECTED]> writes:
hua> Hi,
hua> I have a html search result page (done in jsp/servlet) containing lines of
hua> found records.
hua> our client like to set up a save button on this page and it will invoke word
hua> or excel window which will contain all the result data in Text(tab delimited
hua> .txt) format or in CSV(Comma delimited .csv). then they can save as the
hua> files to their local disk.
hua> can someone share some idea or offering some sample code to implement this
hua> kind of application?
hua> I assume I can set ContextType to some MIME type to invoke excel or word,
hua> but how the data in the page can be transfored to the excel or word in a
hua> certain format? I need detailed help.
The text format for excel is very simple. Each field is separated by
a tab, and each line is separated by a newline.
If the contentType is "application/vnd.ms-excel", then the browser
will interpret it as an excel document, on Windows, at least. With
IE, it puts it in the browser window, and in netscape, it has to open
a separate Excel window (unless there is some way to integrate it into
the browser window, which I'm not familiar with).
So your operation could execute a servlet which would just set the
contentType, and output the data in tab-delimited format.
For an example, pick up the book "Core Servlets and JavaServer Pages",
and look at page 254, for the section "Generating Excel Spreadsheets".
--
===============================================================================
David M. Karr ; [EMAIL PROTECTED] ; w:(425)487-8312 ; TCSI & Best Consulting
Software Engineer ; Unix/Java/C++/X ; BrainBench CJ12P (#12004)
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
