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(); } } }