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
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);
}
}
[…] a comment » before going to use this post My strong advice to see this post […]
inserting data into excel sheet using JExcel API « JavaMix
May 1, 2009 at 3:34 pm
article is much Handy and clear, thank you
rakesh
May 21, 2009 at 5:50 pm
@rakesh
thanQ
katta vijay
May 21, 2009 at 6:05 pm
Hi Vijay,
I need your help how to convert text into wav file using FreeTTS
http://forums.sun.com/thread.jspa?threadID=5371491&tstart=0
Thanks
Regards
Rajesh
Rajesh
June 1, 2009 at 3:53 pm
@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 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
Rajesh
June 1, 2009 at 4:58 pm
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
Rajesh
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) http://forums.sun.com/thread.jspa?messageID=10653752#10653752
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
Rajesh
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
Rajesh
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: rajeshsofware@gmail.com
Rajesh
June 1, 2009 at 5:57 pm
throwing error main not found
but i have checked very thing
chris
August 20, 2010 at 4:38 pm
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
rajesh
June 11, 2009 at 5:31 pm
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.
Uma
September 11, 2009 at 9:46 am
Excuse me for writing OFFTOPIC … which WP theme do you use? It’s looking interesting.
Jaccuccawbamy
December 12, 2009 at 10:36 am
@Jaccuccawbamy
The Journalist v1.9 by Lucian E. Marin,
you can find it here http://lucianmarin.com/page/themes/
katta vijay
December 12, 2009 at 6:41 pm
[…] going to use this post My strong advice to see this post […]
Inserting data into excel sheet using JExcel API at JavaMix
January 2, 2010 at 2:02 am
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
Jagadis
January 30, 2010 at 2:59 pm
Thanks. Its a very useful post
Premalatha
March 29, 2010 at 6:04 pm
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 WordPress.com therz only WordPress.org… so thx in advance..! my email id is hitesh.parmar915@gmail.com and my WordPress id is http://parmarhh.wordpress.com/
Thx Bye Bye.
parmarhh
August 3, 2010 at 10:19 pm
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?!
Jonas
January 3, 2012 at 10:12 pm