Originally Posted by santosh_tamse
especially hi to those who is reading this question
i m writing a program in which i hav to write to excel file the contents of access database using jsp.can i use apache poi & please suggest me how to use it.
reply as fast as u can. it is very important to me.
I am not a jsp user, but if I understood your issue, you want to get an excel file from a web page, in this case made with jsp.
I did this with php, and it's quite easy.
1. you select the information of your database
2. create a string on the format csv (comma separated) as that file can be saved as file.xls and opened by excel
3. output the file as HTML header to force browser to save excel file
This would be a php header set to be able to output a "Save as...":
header("Content-disposition: attachment; filename=".$filename);