Skip to main content

how to download a excel sheet data ?

2 replies [Last post]
PP_1234
Offline
Joined: 2013-11-18
Points: 0

hi i have a application,in this i imported excel sheet data into database,and i retrieved the data also,now when i retrieved the data,the data will be shown in website with table format,in this table format i have 50 rows with check box selection,i want to download the 25 rows from it,i need to select the 25 check boxes and download that data,how it is possible?can any one please help me how it is possible,i am very new to this java,please help me?

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
arnavkumartechno
Offline
Joined: 2013-10-25
Points: 0

Re: how to download a excel sheet data

As Syed_Naved_Aali said POI is used to store or retrieve excel data. You can you use AJAX to show your data in the way you want. AJAX and POI, both are open sources.

Syed_Naved_Aali
Offline
Joined: 2013-11-28
Points: 0

Multiple solution are there. The easiest solution is, once you are done checking your desired check-boxes send the unique identifier of rows to server then make a separate DB call to fetch data respective to unique identifier then use apache POI to create desired excel and using output stream send response back to client.