I have a program that reads in an Excel (.xls) and stores and parses it out in an ArrayList from a FileInputStream. All that works fine. But now I want to pass each "element" to a method to write it to a New .xls file.
Pseudocode: for each element/object in the ArrayList, pass it to OutputFile cell. - Meaning InputFile cell/column 0,0 pass it to cell/column 0,0 to OutputFile...cell/column 0,1...etc
I can pass the List to the "write" class/method I am using to parse.. (to console currently) but I can not:
1. write to console single cell by single cell,
2. pass from the FileInputStream to the parsing method as a single object.
I am using org.apache.poi.hssf library (first time using) and not sure if .jxl or javaexcelapi is better...of if using an ArrayList to store the FileInputStream is a bad idea..not sure why it would be other than a better iterating way to get each element out to pass to my parser for outputting the individual cells. - Just looking for some ideas to be able to pass in singel cell values into the cell.setCellValue() that are not hard coded.
Thanks to all