This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Re: Creating Excel in a servlet

Posted by Andreas on October 27, 2000 at 3:58 AM

> Hi, i just want to ask how can i create an excel file in java servlets? i have found one but it uses VJ++.
> thanks

Sorry, the posting didn't have the expected result. The listing I've
transmitted was different.

I'll try it again.

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class xls extends HttpServlet {

public void doGet( HttpServletRequest request,
HttpServletResponse response)
throws IOException,
ServletException
{

StringBuffer result = new StringBuffer();

response.setContentType(\"application/vnd.ms-excel\");

//response.setContentType(\"text/html\");

PrintWriter out = response.getWriter();

result.append(\"\");
result.append(\"\");
result.append(\"\");
result.append(\"\");

result.append(\"

\");
result.append(\"\");
result.append(\"\");

result.append(\"

\");
result.append(\"\");
result.append(\"\");

result.append(\"

\");
result.append(\"\");
result.append(\"\");

result.append(\"

ID	Kunde	ADatum	ASumme
1	Maier	4.1.99	200,12
2	M�ller	03.10.2000	2000
3	Meckes	22.12.1989	400.60

\");

out.println( result.toString() );

}
}