hi guys i m using struts framework... i m gettin data using queries nd displayin it as a iterated table in my jsp page.. i need to export the fetched data as a excel sheet .. how do i approach this problem??? kindly help me..
thanks for the reply , i tried the links you sent... its mainly to read and write excel sheet.. i want my table to be exported as a excel sheet so that users can download it to excel sheet and take print outs of it... can you be more specific and clear in solution...
Yes, thats right. These APIs give you a provision to read and write the data into Excel sheets. What you can do is, the same data which you read and give it to HTML for rendering in the browser, you can pass it to the API so that it can write it into the Excel Sheet.
If you are passing a collection (say an ArrayList) to a JSP for rendering/writing it into HTML, you can pass the same list of values to any of these APIs and you need to manipulate how they are supposed to be written into the Excel sheet of your choice!
Does that help? Go through some tutorials/documentation on 'how to use' the API. You may get more clear information.