write Excel through servlet

Thread view:

finecur - 05 Apr 2007 05:07 GMT

Here is my servlet:

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

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

    response.addHeader("Pragma", "no-cache");
    response.setHeader("Cache-Control","no-cache");
response.setDateHeader ("Expires", 0);

PrintWriter out = response.getWriter();
    out.println("<html>");
    out.println("<body>");
    out.println("<table border=1>");
    out.println("<tr>");
    out.println("<th>A</th>");
    out.println("<th>B</th>");
    out.println("</table>");
    out.println("</body>");
    out.println("</html>");
}

When I call it from http://www.mydomain.com/myservlet.do?mypara=1 in
IE 7, it says

"Do you want to open or save this file?
Name:myservlet_do?mypara=1
Type:Microsoft Ecel Worksheet, 733
Form:www.mydomain.com
"

Then I click "Open",

but it says" Can not open the file", and the IE page went black.

Does anyone know why?

Thanks,

ff

Reply to this Message

LuckyBoy - 05 Apr 2007 05:34 GMT

This is a Bug in IE Header. Search Sun discussion forums and you will
get the answer. Did you try in Firefox or Other browser ? What does it
say then ?

Reply to this Message

Sanjay - 05 Apr 2007 16:08 GMT

> Here is my servlet:
>
[quoted text clipped - 38 lines]
>
> ff

I had exact same problem couple of years ago. I guess you code works
fine with Firefox or mozilla. Because your cache expires in 0 seconds,
what IE does in my opinion is downloads the file and because it expires
in 0 seconds deletes it and now can not open it.

Try setting "expires" header to some value like 2 minutes etc. That
should work.

Reply to this Message

write Excel through servlet

Free Magazines