Java Code to Read Excel File Without Using DSN

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Locale;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.read.biff.BiffException;
import jxl.DateCell;
public class ReadXLSheet {
public void init(String filePath) {
FileInputStream fs = null;
try {
fs = new FileInputStream(new File(filePath));
contentReading(fs);
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}finally {
try {
fs.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
//Returns the Headings used inside the excel sheet
public void getHeadingFromXlsFile(Sheet sheet) {
int columnCount = sheet.getColumns();
for (int i = 0; i < columnCount; i++) {
System.out.println(sheet.getCell(i, 0).getContents());
}
}
public void contentReading(InputStream fileInputStream) throws BiffException {
WorkbookSettings ws = null;
Workbook workbook = null;
Sheet s = null;
Cell rowData[] = null;
int rowCount = '0';
int columnCount = '0';
DateCell dc = null;
int totalSheet = 0;
try {
ws = new WorkbookSettings();
ws.setLocale(new Locale("en", "EN"));
workbook = Workbook.getWorkbook(fileInputStream, ws);
totalSheet = workbook.getNumberOfSheets();
if(totalSheet > 0) {
System.out.println("Total Sheet Found:" + totalSheet);
for(int j=0;j System.out.println("Sheet Name:" + workbook.getSheet(j).getName()); }
}
//Getting Default Sheet i.e. 0
s = workbook.getSheet(0);

//Reading Individual Cell
getHeadingFromXlsFile(s);

//Total Total No Of Rows in Sheet, will return you no of rows that are
occupied with some data
System.out.println("Total Rows inside Sheet:" + s.getRows());
rowCount = s.getRows();
//Total Total No Of Columns in Sheet
System.out.println("Total Column inside Sheet:" + s.getColumns());
columnCount = s.getColumns();
//Reading Individual Row Content
for (int i = 0; i < rowCount; i++) {
//Get Individual Row
rowData = s.getRow(i);
if (rowData[0].getContents().length() != 0) { // the first date
column must not null
for (int j = 0; j < columnCount; j++) {
switch (j) {
case 0:
System.out.println("Employee Id:" +
rowData[j].getContents());q
case 1:
System.out.println("Employee Name:" +
rowData[j].getContents());
case 2:
System.out.println("Employee Designation:" +
rowData[j].getContents());
default:
break;
}
}
}
}
workbook.close();
} catch (IOException e)
{
e.printStackTrace();}

}
public static void main(String[] args) {
try {
ReadXLSheet xlReader = new ReadXLSheet();
xlReader.init("Desktop\\test.xls");
} catch (Exception e) {
e.printStackTrace();
}
}
}

Download jxl-2.6.jar file

http://www.findjar.com/jar/net.sourceforge.jexcelapi/jars/jxl-2.6.jar.html