File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Open .csv file within jsp

 
uday chovatiya
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which content type did you try for CSV?
If I remember correctly, you should use something like "application/csv" instead of "text/csv".
 
Philip Shanks
Ranch Hand
Posts: 189
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic