Hello Srini!!
Here is my post!!!
-----
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition","attachment;filename=\"" + date_num + "\"");
.....
here date_num variable is for name of file in terms of date
string.
I am working with Mysql,
jsp,excel,linux.The above code line works pefectly.And i am able to see the data in Excel sheet. But the problem is that ,The excel file is opening in the name like
http://www.localhost/21.jsp?list=20051002?list= When user wants to save the excel file,default will be (html*,htm*)...But the requirement is to save in .xls extension (Note: user should not go on to edit filename while saving it)
Point: I am not downloading the file from server, infact it is generated dynamically .... And displaying in the excel.
One more thing : I want to open excel file with in the explorer browser
any Idea. I have tried by replacing attachment with inline...but didnt work.
Help Me!!!
Thanks in Advance