code to transfer the data in jsp to excel sheet

[Raghu D]

hi ! Actually the operation is as follows.when the user clicks the"search" button in t he jsp, the datas from mysql is sent to jsp page.If the user likes to print the datas,he has to click "print" button.Then the datas in the jsp page has to be sent to the excel sheet ,so that he can printout............... i need help to achieve this task..........thank u.......

[sweetheartjava]

<%response.setContentType("application/vnd.ms-excel"); %>

[Raghu D]

<%response.setContentType("application/vnd.ms-excel"); %>

Hi ! i tried with the given code.But my task is that the user should able to see the "search results" in the internet explorer .If they like to take print,then they want to click "print" button.then only the displayed result sholud be transfered to excel sheet.......so,is it possilbe to use the given code inside the script...........kindly help me...........thank u.........

[Raghu D]

thanks..................i got the logic.............

[Ramkeeys]

@Raghu:Hi i too have the same problem...Can u help me with it ,if u dont mind....