This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
Dear All, im new to Jakarta POI i want to generate excel file.I used HelloExcel examples and it work greately.But my problem is : if i have ArrayList of beans and i want to iterate them in EXcel how to make that in dynamic way. i want to make method to give it this ArrayList and it will iterate and generate Excel file. Is that possible please tell me?
Im stuck with an idea not how to iterate like make a method to give it an arraylist and it is complete to add cells . because i cant know when this method recived X # of columns and N # of rows how to manage that Dynamically?
Joined: Mar 22, 2005
A list is one-dimensional, while a spreadsheet it two-dimensional. You will need to determine beforehand how to distribute the list elements over the spreadsheet area. So - how should that work?
(A row in an Excel sheet can have up to 255 cells, if that's any help.)