Can Any body tell me how to open excel sheet seperately using
JSP.
Here in our application.I am generating a table in Jsp page when i click on a button i am getting a message box with button "open" and "save". When i click on 'save' it is saving the table to selected path in excel format. Now when i click on "open". it is not able to open this table in excel sheet.
When i open excel application and click on "open" button this time it is opening my table in excel sheet.
What i need is when i click on "open" button without opening MS Excel application it should open my table in a specified location with specified name. Pls tell me the code for this.
I have used the following code in my application.pls tell me the modifications or additions for this to get my requirement
response.setContentType("application/vnd.ms-excel; charset=UTF-8");
response.setHeader("Content-Disposition", "attachment; filename=table.xls");
response.setHeader("Content-Language","EN");
response.setHeader("Vary","Accept-Language");
response.setHeader("Cache-Control", "no-cache, post-check=0, pre-check=0");
response.setHeader("pragma", "no-cache");
response.setHeader("Cache-Control", "no-store");