Hi all,
Consider I have a URL -
http://someurl/file.xls
I need to do a response.sendRedirect(url) into this url. This opens the file in the browser itself. But I need to open it in microsoft excel.
Normally we have a the content of the excel file (html table format)
then we do response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=data.xls");
outwriter.writeln(html table content);
this gives us the content in an ms excel window rather than browser. Instead of attachment above if we say inline, it'll open the contents in the browser itself but will look like excel but goofier.
The content when too large can't be manipulated on the server due to memory issues so I want to do have the file in a url link and do sendRedirect, but open it in msexcel itself.
Is it possible? Could anyone please help me in solving this?
Thanks
Ranji