how to download excel sheet from unix operating system

[Ritu Pande]

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]

try doing this Ritu:

// Set these headers.
response.setContentType("application/x-download");
response.setHeader("Content-Disposition", "attachment; filename=" + excelFileName);
 
// Send the file.
OutputStream out = response.getOutputStream(  );
//Add code to send a file using FileInputStream etc

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]

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]

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.

[R K Parulekar]

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..

[Aniken]

public class MyDownloadAction extends DownloadAction {    private AccountingManager someService;    
// --------------- START Injection ------------------    
public void setSomeService(AccountingManager someService) {
        this.someService = someService;
    }    // --------------- END Injection ------------------    
protected StreamInfo getStreamInfo(ActionMapping mapping, ActionForm form, 
                                       HttpServletRequest request,
                                       HttpServletResponse response) throws Exception 
{        String oid = request.getParameter("oid");        // Load data
        DHLAccountingHistory historyEntry = 
                        someService.getDHLAccountingHistoryEntry(oid);       // Set the content disposition
        response.setHeader("Content-disposition","attachment; filename=" + 
                   historyEntry.getFilename());        String contentType = "application/text";
        byte[] myBytes = historyEntry.getCsvData().getBytes();
        return new ByteArrayStreamInfo(contentType, myBytes);
    }    protected class ByteArrayStreamInfo implements StreamInfo {        protected String contentType;
        protected byte[] bytes;        public ByteArrayStreamInfo(String contentType, byte[] bytes) {
            this.contentType = contentType;
            this.bytes = bytes;
        }        public String getContentType() {
            return contentType;
        }        public InputStream getInputStream() throws IOException {
            return new ByteArrayInputStream(bytes);
        }
    }
}

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

[Mark Spritzler]

"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

[Aniken]

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]

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???