it`s all about JavaPrograming

Reading data from Excel sheet using JExcel API

using Java we can read the data from Excel sheets by creating type1 driver , but here

we are taking help of JExcelapi we can able to read data directly from the Excel sheets.
steps to be follow:
step 1:
download JExcel api from here

JavaMix Blog


after downloading extract the zip file.
make jxl.jar available to your class path.

step 3:

create a Excel sheet with some data

step 4:

in this step we are reading data from the Excel sheet.

use the below java code:


* To change this template, choose Tools | Templates

* and open the template in the editor.


// this is main java program

//describes how to read from the .xls and displays

package excelsheetreading; // my package name



import java.util.Date;

import jxl.*;




* @author vijay


public class Main // main is my class name



* @param args the command line arguments


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

// TODO code application logic here

Workbook workbook = Workbook.getWorkbook(new File(“C:/Documents and Settings/vijay/Desktop/contacts.xls”));

// my excel sheet name is contacts, iam given the complete path.

Sheet sheet = workbook.getSheet(0); // iam reading data from the sheet1

// here iam reading the data of 1st column data up three cells

Cell a1 = sheet.getCell(0,0);

Cell b2 = sheet.getCell(0,1);

Cell c2 = sheet.getCell(0,2);

//gettingĀ  the data from cells

String stringa1 = a1.getContents();

String stringb2 = b2.getContents();

String stringc2 = c2.getContents();

//printing the data






JavaMix Blog

Written by katta vijay

March 26, 2009 at 12:15 pm

21 Responses

Subscribe to comments with RSS.

  1. […] a comment » before going to use this post My strong advice to see this post […]

  2. article is much Handy and clear, thank you


    May 21, 2009 at 5:50 pm

  3. Hi Vijay,
    I need your help how to convert text into wav file using FreeTTS



    June 1, 2009 at 3:53 pm

  4. @rajesh

    how can i help u? where did u strucked up ?

    katta vijay

    June 1, 2009 at 4:07 pm

    • im not able to create .wav file yaar.The below is my the forum you menioned that you solved the probelm of creating the wav file

      import com.sun.speech.freetts.FreeTTS;
      import com.sun.speech.freetts.Voice;
      import com.sun.speech.freetts.VoiceManager;

      public class VoiceTest {

      * @param args the command line arguments

      public void audioGenerated(String s)
      Voice voice;

      FreeTTS freetts=new FreeTTS(voice);
      for(int i=0;i<s.length();i++)
      String talk=String.valueOf(s.charAt(i));
      public static void main(String args[])
      VoiceTest voice =new VoiceTest();
      String s="rajesh";




      June 1, 2009 at 4:58 pm

      • i tried theses two lines






        June 1, 2009 at 4:59 pm

      • ok,
        what kind of application ur developing ?
        if ur developing a web application the code at (reply 3 of 10)
        is working perfectly.
        do u need explanation for that code ??
        ask me.

        katta vijay

        June 1, 2009 at 5:33 pm

      • My Application is the webapplication, my requirement is to develop voice based captcha.for that im usisng FreeTTS.What the problem in my code yaar.why the output file is not created


        June 1, 2009 at 5:50 pm

      • Hi Vijay,
        The code in the reply3 of 10 in the forum is not working.i.e he output wav file is not created.if possible can u send me any code that works fine with creating output wav file


        June 1, 2009 at 5:57 pm

      • Hi Vijay,
        The code in the reply3 of 10 in the forum is not working.i.e he output wav file is not created.if possible can u send me any code that works fine with creating output wav file.can u send me ur gmail id .mine is GTALK:


        June 1, 2009 at 5:57 pm

    • throwing error main not found
      but i have checked very thing


      August 20, 2010 at 4:38 pm

  5. Hi Vijay,
    Sorry for disturbing u again.My code is working fine now.but one thing im getting in my console always “System property “mbrola.base” is undefined. Will not use MBROLA voices”. how to avoid this message. client ask me to look into this issue as an error message.

    please help me if u find time



    June 11, 2009 at 5:31 pm

  6. how to read data from excel file using column name.
    Say for eg,
    Place Country
    Chennai India
    Mumbai India
    Need to read using the column Place, Country.
    Please help me out.


    September 11, 2009 at 9:46 am

  7. Excuse me for writing OFFTOPIC … which WP theme do you use? It’s looking interesting.


    December 12, 2009 at 10:36 am

  8. @Jaccuccawbamy
    The Journalist v1.9 by Lucian E. Marin,

    you can find it here

    katta vijay

    December 12, 2009 at 6:41 pm

  9. […] going to use this post My strong advice to see this post […]

  10. Hi…. Thanks for this useful post.. But Can you explain how to fetch all the rows from the excel sheet? here its just for three rows. The files that i use have a variable row count. So i need to be able to write a code that adapts to the length of the row


    January 30, 2010 at 2:59 pm

  11. Thanks. Its a very useful post


    March 29, 2010 at 6:04 pm

  12. hi there u doin a good job… i need ur help in adding this feedjit can u help me to add this widget in the wordpress blog. coz tere is no any option for the therz only… so thx in advance..! my email id is and my WordPress id is
    Thx Bye Bye.


    August 3, 2010 at 10:19 pm

  13. OMG! Finally I found something simple and so clear! Thanks. But.. I cant read one of my excel files I got error:

    Text Object on sheet “Mesafeler Cetveli” not supported – omitting

    Any chance you know something about it?!


    January 3, 2012 at 10:12 pm

Comments are closed.


Get every new post delivered to your Inbox.

%d bloggers like this: