Excel file opening problem

[sreenath reddy]

Hi

I am trying to open an excel file by clicking a link where it goes to action class and then sets the content type to excel and I am opning it from there�but the strange thing is that a file download opens with open/save/cancel but in the same window but it is showing a warning in the dailog box(windows warning which comes as an exclamatory mark) saying "This type of file could harm your computer if it conatins malicious code" and on cliking open it shows a dialog saying "Could not open http://localhost:8080/context/myaction.do?fileName=3.xls" .Dont know why its trying to opne my action url rather than it should look for 3.xls in my folder

Any clue on this would be helpful

[Marc Peabody]

You might need to have the action do a redirect to the file.

[sreenath reddy]

Yah marc

I am opening it by redirecting to that url ths is my code which i am using to opnen that file in an action class

String format = request.getParameter(WebConstants.FORMAT);
String reportId = request.getParameter(WebConstants.REPORT_ID);
HttpSession session = request.getSession();
String sFilePath = WebConstants.REPORT_PATH + reportId
+ ReportUtil.getFormatExtn(format);
if (format.equals(WebConstants.EXCEL)) {

response.setContentType("application/vnd.ms-excel");


}

// This is to enable him to go to the listing page of reports
request.setAttribute(CommandConstants.CmdID, CommandConstants.LIST_RPT);

return new ActionForward(sFilePath,false);

[Marc Peabody]

Shouldn't it be:
return new ActionForward(sFilePath,true);
for a redirect?

[sreenath reddy]

Hi marc

If i make that true ,then request and response will be lost which results the excel file being opened as junk ....so i need to set the contenttype header to excel .so i need to persist the response attributes hence false is used