Hi
I am generating a report using JSP. To get the report as an
excel attachment i have added this piece of code:
-----------------------------------------------------------
response.setContentType("application/vnd.ms-excel");
response.setHeader
("Content-Disposition","attachment;filename=Search.xls");
-----------------------------------------------------------
When the jsp is called a new browser window is opened and it
pops up the familiar save file/open from current location
dialog.

1. When open file option is chosen i want to prompt for password before the sheet can be viewed. Is this possible?

2. If the above is not possible is there any way i can encrypt the password in the jsp and then decrypt it before accessing the excel database from the jsp.

This is quite important. So i would be really grateful if someone could help me as soon as possible.

Thank You
Lina