Write the entries in comma separated format in a foo.csv file.
eg.
ur arrays are col1[100]
col2[100]
col3[100]
Proposed logic
StringBuffer sb = new StringBuffer();
for( int i = 0; i < 100; i++ )
{
sb.append( col1[i] );
sb.append( "," );
sb.append( col2[i] );
sb.append( "," );
sb.append( col3[i] );
sb.append( "\r\n" );
}
// Place the PrintWriter to writer to write the StringBuffer
// into a file.
// Name the file as foo.csv
// Excel internally uses a comma (,) separated format, so it
// understand your file.
-HTH
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Lorena Carlo
Sent: Thursday, September 28, 2000 12:33 AM
To: [EMAIL PROTECTED]
Subject: How can I export data to EXCEL usign JSP
Hello all,
Does anybody know how can I export data from arrays to and EXCEL file using
JSP?
Thanks in advance
Lorena
===========================================================================
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
===========================================================================
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
