Hi All, I have a .csv file being created be back end in server. I am trying to open this file within jsp in Excel. I could display .xsl file in JSP by changin the content type attribute of page directive. But I could not find the way do following in jsp: 1)read this .csv file. 2)open the excel. 3)open this file in Excel. Your prompt response is highly appriciated. Thanks in advance
posted 13 years ago
Which content type did you try for CSV? If I remember correctly, you should use something like "application/csv" instead of "text/csv".
Here's what I do: <%@page contentType="text/x-csv" session='true' errorPage='error.jsp'%> and then, after I have set a variable up as a filename for download purposes, <%response.setHeader("Content-disposition","filename=" + type + ".csv"); %> This ensures that the client gets a "save or open" prompt, and provides the save case with a default filename. [ April 22, 2003: Message edited by: Philip Shanks ]
Philip Shanks, SCJP - Castro Valley, CA
My boss never outsources or has lay-offs, and He's always hiring. I work for Jesus! Prepare your resume!
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads