Hi I am trying to read an excel sheet for the purpose of writing it into database.By the below code ,I am getting the contents of the cell in first row,first column..Can you please help me to iterate it for the number of rows and columns.Little bit urgent...
Ya..I do have a knowledge in JDBC Api...But the thing is,I dont know how to store the values which I get from the excelsheet cells to some variables,so that only I can use them in my queries..
Joined: Sep 21, 2011
Doesn't "String stringa1 = a1.getContents()" do that? I'm not familiar with jExcelAPI, buit if that's not the right method then the Cell class should have other methods that do return the correct data from the cell.