How to read xls, xlsx and open office excel formats from java. Any pointers ? Kindly help.

[Deepak S Babu]

I used XSSF but not successful. Code Below.


While running (compilation was successful) getting as Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/Workbook

import java.io.*;
import java.util.*;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ReadFile {

public static void main(String[] args) {

String fileName = "C:\\Details.xlsx";
Vector dataHolder = ReadFile(fileName);
read(dataHolder);
}

public static Vector ReadFile(String fileName) {
Vector cellVectorHolder = new Vector();
try {
FileInputStream arquivo = new FileInputStream(fileName);
XSSFWorkbook planilha = new XSSFWorkbook(arquivo);


XSSFSheet aba = planilha.getSheetAt(0);
Iterator rowIter = aba.rowIterator();

while (rowIter.hasNext()) {
XSSFRow myRow = (XSSFRow) rowIter.next();
Iterator cellIter = myRow.cellIterator();

Vector cellStoreVector = new Vector();
while (cellIter.hasNext()) {

XSSFCell myCell = (XSSFCell) cellIter.next();
cellStoreVector.addElement(myCell);
}
cellVectorHolder.addElement(cellStoreVector);
}
} catch (Exception e) {
}
return cellVectorHolder;
}

private static void read(Vector dataHolder) {
for (int i = 0; i < dataHolder.size(); i++) {
Vector cellStoreVector = (Vector) dataHolder.elementAt(i);

for (int j = 0; j < cellStoreVector.size(); j++) {
XSSFCell myCell = (XSSFCell) cellStoreVector.elementAt(j);
String stringCellValue = myCell.toString();
System.out.print(stringCellValue + "\t");
}
System.out.println();
}

}
}

[Lester Burnham]

It looks like you don't have all the required POI jar files in the classpath; the missing would be named poi-3.7-20101029.jar or something like that.

[Christophe Verré]

Welcome to the ranch !

Next time you want to post some code, please UseCodeTags. I'll add them for you this time.