Similar Posts


  1. Hi Sir,

    i need complete Selenium notes how u have given manual. please send it to my mail id
    your way of explanation is very clear . thank you so much for your wonderful job

  2. dear sir,
    I am trying your code, but I got an error

    “Exception in thread “main” java.lang.NoClassDefFoundError: org/openxmlformats/schemas/drawingml/x2006/main/ThemeDocument
    at java.lang.Class.getDeclaredConstructors0(Native Method)
    at java.lang.Class.privateGetDeclaredConstructors(
    at java.lang.Class.getConstructor0(
    at java.lang.Class.getDeclaredConstructor(
    at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(
    at org.apache.poi.POIXMLFactory.createDocumentPart(
    at org.apache.poi.POIXMLDocument.load(
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.(
    at readExcelFile.main(
    Caused by: java.lang.ClassNotFoundException: org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument
    at java.lang.ClassLoader.loadClass(
    at sun.misc.Launcher$AppClassLoader.loadClass(
    at java.lang.ClassLoader.loadClass(
    … 10 more

    this is my code:

    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 readExcelFile {
    public static void main (String [] args) throws IOException{

    //I have placed an excel file ‘Test.xlsx’ in my D Driver
    FileInputStream fis = new FileInputStream(“/Users/ekobudiharto/Documents/soapUIworkspace/skyvva/testExcelFile.xlsx”);
    XSSFWorkbook wb = new XSSFWorkbook(fis);
    //XSSFSheet sheet = wb.getSheetAt(0);
    ////I have added test data in the cell A1 as “”
    ////Cell A1 = row 0 and column 0. It reads first row as 0 and Column A as 0.
    //Row row = sheet.getRow(0);
    //Cell cell = row.getCell(0);
    ////String cellval = cell.getStringCellValue();

    can you tell me what cause the error? I already imported the libraries.

  3. Hi Eko Budiharto,

    Are you using Maven Project? which version of poi jars you are using..
    If it is a maven project – Add poi-ooxml-schemas jar dependencies in your pom.xml file
    If it is a java project – Add poi-ooxml-schemas jar in the lib directory.

Leave a Reply

Your email address will not be published. Required fields are marked *