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
Joined: Jan 23, 2002
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!