To read data from excel using jxl.jar
807589Sep 30 2008 — edited Sep 30 2008I have downloaded the jxl.jar and placed under java lib folder.I have written the code to read the data from excel which i placed below.
But its showing "xxx.xls not found". Could you please tell me where to place the Excel file and how to link it with jxl. Do i need to give the excel file path explicitly?
File fp = new File("WONSpec.xls");
Workbook wb = Workbook.getWorkbook(fp);
Sheet sheet = wb.getSheet(0);
int columns = sheet.getColumns();
int rows = sheet.getRows();
String data;
for(int col = 0;col < columns;col++) {
for(int row = 0;row < rows;row++) {
data = sheet.getCell(col, row).getContents();