BE THE CODER > Excel > Java Excel API Examples > How to read Contents of all Cells in Excel Spreadsheet

Java Excel API is an open source java library to read, write and modify Excel spread sheets. This requires the library jxl-2.6.12.jar to be in classpath. The following example shows how to read the contents of all Cells in a Spread sheet as a String.

File Name :	com/bethecoder/tutorials/jexcelapi/read/GetCellContentTest2.java
Author :	Sudhakar KV
Email :	[email protected]


package com.bethecoder.tutorials.jexcelapi.read;



import java.io.File;

import java.io.IOException;



import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;



public class GetCellContentTest2 {



  /**

   * @param args

   * @throws IOException 

   * @throws BiffException 

   */

  public static void main(String[] args) throws BiffException, IOException {

    Workbook workbook = Workbook.getWorkbook(new File("C:/JXL/Test.xls"));



    Sheet firstSheet = workbook.getSheet(0); 

    System.out.println("Rows in first sheet : " + firstSheet.getRows());

    System.out.println("Columns in first sheet : " + firstSheet.getColumns());

    System.out.println();

    

    for (int row = 0 ; row < firstSheet.getRows(); row ++ ) {

      for (int column = 0 ; column < firstSheet.getColumns(); column ++) {

        System.out.print(firstSheet.getCell(column, row).getContents() + "\t\t");

      }

      System.out.println();

    }

    

    //Close and free allocated memory 

    workbook.close(); 

  }



}