Excelsheet content reading

[Arun vel]

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...

import java.io.File;
import java.io.IOException;
import java.util.Locale;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.biff.formula.FormulaException;
import jxl.read.biff.BiffException;
import jxl.write.WriteException;

public class ReadExcel
{
	public static void main(String[] args) throws IOException, WriteException, BiffException, FormulaException
	{
        try
        {
        	File f1=new File("D:\\exercise\\ExcelFiles\\Arun.xls");
        	WorkbookSettings ws=new WorkbookSettings();
        	ws.setLocale(new Locale("er","ER"));
        	Workbook workbook=Workbook.getWorkbook(f1,ws); 
        	Sheet readsheet=workbook.getSheet(0);
        	//System.out.println(readsheet.getName());
        	Cell a1 = readsheet.getCell(0,0); 
         	String stringa1 = a1.getContents(); 
              	System.out.println(stringa1);
        }
        catch(IOException e)
        {
        	e.printStackTrace();
        }
        catch(BiffException e)
        {
        	e.printStackTrace();
        }
	}
}

[Zeeshan Sheikh]

After you have the first sheet you can iterate using the for loop

for (int j = 0; j < sheet.getColumns(); j++) { //get columns
for (int i = 0; i < sheet.getRows(); i++) { //get rows
//whatever you want to do

[Arun vel]

Okay...Now I am getting the values of all the rows and columns..How can I store the value of each columns(as a field) for the purpose of storing in the database..
Thanks for the reply..

[Tim Moores]

What difficulty are you facing in storing those values in the DB? Are you familiar with the JDBC API?

[Arun vel]

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..

[Tim Moores]

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.

[Arun vel]

Ya...this is working...I have already tried...But it will retrieve the contents of a particular cell only...But I want to read all the cell(records) to a number of rows...

[Tim Moores]

Sounds like a loop (or maybe two nested loops) would be involved.