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:

Creating Excel in a servlet

Posted by Andreas on October 27, 2000 at 3:49 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

Hi,

you could use this code as an example.

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() );

}
}

• More Information Sunil Kumar Kar April 26, 2001 at 6:29 PM (1)
  • Excel Sheets from Servlet Sanjay December 05, 2001 at 10:38 PM (0)
• Thanks. Juwel patil April 11, 2001 at 4:25 AM (0)