How can i store a data from Excel sheet to an array.
I want to Read an Open office excel file(.ods File) and need to fetch record row by row. Is there any method where i can use the data line by line and print it to the file that i have already created.
I want to write the cell.getValue() into Files. Like first row into first File, 2nd Row into 2nd file and So on.....
public static void ReadOds(File f1)
Writer output = null;
sheet = SpreadSheet.createFromFile(f1).getSheet(0);
int nColCount = sheet.getColumnCount();
int nRowCount = sheet.getRowCount();
MutableCell cell = null;
for(int nRowIndex = 0; nRowIndex < nRowCount; nRowIndex++)
please suggest me the way how can i make this simple and how to find the array size dynamically if my data is huge.
Thanks In Advance......