| |

Reading data from Excel sheet using JExcel API

ByVijay Katta
Reading Time: 2 minutes

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

step2:

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.io.File;

import java.io.IOException;

import java.util.Date;

import jxl.*;

import jxl.read.biff.BiffException;

/**

*

* @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

System.out.println(“a1–>”+stringa1);

System.out.println(“b2–>”+stringb2);

System.out.println(“c3–>”+stringc2);

}

}

JavaMix Blog


Similar Posts

41 Comments

  1. Pingback: inserting data into excel sheet using JExcel API « JavaMix

    1. im not able to create .wav file yaar.The below is my code.in 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;

      voice=VoiceManager.getInstance().getVoice(“kevin16”);
      if(voice!=null)
      {
      voice.allocate();
      }
      FreeTTS freetts=new FreeTTS(voice);
      for(int i=0;i<s.length();i++)
      {
      String talk=String.valueOf(s.charAt(i));
      voice.speak(talk);
      }
      freetts.startup();
      freetts.shutdown();
      }
      public static void main(String args[])
      {
      VoiceTest voice =new VoiceTest();
      String s="rajesh";
      voice.audioGenerated(s);
      }

      }

      Thanks
      Regards
      Rajesh

      1. i tried theses two lines

        freetts.setStreamingAudio(true);
        freetts.setAudioFile(“c:\\test.wav”);

        like

        freetts.startup();
        freetts.setStreamingAudio(true);
        freetts.setAudioFile(“c:\\test.wav”);
        freetts.shutdown();

        Thanks

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

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

      5. 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: rajeshsofware@gmail.com

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

    Thanks
    Rajesh

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

    Thanks
    Rajesh

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

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

  16. Pingback: Inserting data into excel sheet using JExcel API at JavaMix
  17. Pingback: Inserting data into excel sheet using JExcel API at JavaMix

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

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

  24. 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?!

  25. 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?!

Comments are closed.