aspose file tools*
The moose likes Servlets and the fly likes how to download excel sheet from unix operating system Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "how to download excel sheet from unix operating system" Watch "how to download excel sheet from unix operating system" New topic
Author

how to download excel sheet from unix operating system

Ritu Pande
Greenhorn

Joined: Jun 05, 2005
Posts: 17
hi,

I am creating an excel sheet and storing it in application server which runs on HP-UNIX OS. I want to download that excel sheet using jsp page. I tried the following code, but its giving the page cannot be displayed error. Is there any other way to download the excel sheet from jsp page.
<%
out.println("<a href=\"../XlsDownload/Download.xls\">Download</a>");
%>

Thx in adv.

ritu
Neeraj Dheer
Ranch Hand

Joined: Mar 30, 2005
Posts: 225
try doing this Ritu:



the above will also work, but you may want to replace the 'x-download' with the specific format for excel files. i dont know what that is.

the difference would be that, browsers that recognise the format will open the file for you in Excel automatically while others will show the 'save as' or equivalent dialog box.
Neeraj Dheer
Ranch Hand

Joined: Mar 30, 2005
Posts: 225
Ritu,

In this case, the code in the above post will set the content type. But when you set te content type as above, that means that you want to download the file specified by 'fileName'. And then you use the OutputStream of the servlet to stream the actual bytes of the file.
So, the effect of the above code is to produce the 'save-as' pop-up dialog box and save the file onto the client.
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

Originally posted by Ritu Pande:
hi,

I tried the following code, but its giving the page cannot be displayed error. Is there any other way to download the excel sheet from jsp page.


What errors are you getting?
Disable the "Friendly error messages" feature in your browser and you should see a more descriptive stack. If not, look in your containers logs.

You should be able to use a regular anchor tag.


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
R K Parulekar
Ranch Hand

Joined: May 29, 2005
Posts: 66
Hi Ritu
Is the problem resolved? What was the issue?Please let me know, even I want to download a simple .csv file from my linux box...

Thank..
Ravi..


"A wish changes nothing. A decision changes everything." - Unknown
Aniken
Greenhorn

Joined: Jun 21, 2005
Posts: 3

[ June 21, 2005: Message edited by: Mark Spritzler ]
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

"Aniken Aniken"-
Welcome to the JavaRanch! Please adjust your displayed name to meet the

JavaRanch Naming Policy.

You can change it

here.

Thanks! and welcome to the JavaRanch!

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Aniken
Greenhorn

Joined: Jun 21, 2005
Posts: 3
used
import org.apache.struts.actions.DownloadAction;

struts-config.xml

<action path="/download"
parameter="download_function"
type="com.MyDownloadAction"
name="MyForm"
scope="request"
input="/invoke_download_action">
<forward name="success"
path="/download_now.do"
redirect="false"/>
<forward name="failure"
path="/download_failure.do"
redirect="false"/>
</action>

<action path="/download_now"
parameter="download" type="MyDownloadAction"/>
Neeraj Dheer
Ranch Hand

Joined: Mar 30, 2005
Posts: 225
Aniken Aniken...please change your name to comnfirm to the naming policy as Mark mentioned...

what you are doing is similar to what i mentioned in my post...
however Ben's idea of using the anchor tag seems profoundly simpler than doing all of that...

the error, and i am only speculating, probably is because the path is somehow not right???
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to download excel sheet from unix operating system