How to solve java.lang.NoClassDefFoundError: org/apache/poi/xssf/usermodel/XSSFWorkbook

Question

 Data Driven Method* Error NoClassDefFoundError: org/apache/poi/xssf/usermodel/XSSFWorkbook 
File scr = new File("Numbers.xlsx"); 
FileInputStream inputStream = new FileInputStream(scr);
XSSFWorkbook wb = new XSSFWorkbook(inputStream);
XSSFSheet sheet1 = wb.getSheetAt(0);
double data0 = sheet1.getRow(1).getCell(0).getNumericCellValue();
String value = NumberToTextConverter.toText(data0);
System.out.println(value);

*How to solve this error *

DEBUG   15421   [freemark] (): Couldn't find template in cache for "Extent.ftl"("en_US", UTF-8, parsed); will try to load it.
DEBUG   15421   [freemark] (): TemplateLoader.findTemplateSource("Extent_en_US.ftl"): Not found
DEBUG   15421   [freemark] (): TemplateLoader.findTemplateSource("Extent_en.ftl"): Not found
DEBUG   15421   [freemark] (): TemplateLoader.findTemplateSource("Extent.ftl"): Found
DEBUG   15421   [freemark] (): Loading template for "Extent.ftl"("en_US", UTF-8, parsed) from "jar:file:/C:/Users/PoojaPatange/.m2/repository/com/relevantcodes/extentreports/2.41.2/extentreports-2.41.2.jar!/com/relevantcodes/extentreports/view/Extent.ftl"
DEBUG   15421   [freemark] (): Couldn't find template in cache for "Extent.ftl"("en_US", UTF-8, parsed); will try to load it.
DEBUG   15421   [freemark] (): TemplateLoader.findTemplateSource("Extent_en_US.ftl"): Not found
DEBUG   15421   [freemark] (): TemplateLoader.findTemplateSource("Extent_en.ftl"): Not found
DEBUG   15421   [freemark] (): TemplateLoader.findTemplateSource("Extent.ftl"): Found
DEBUG   15421   [freemark] (): Loading template for "Extent.ftl"("en_US", UTF-8, parsed) from "jar:file:/C:/Users/PoojaPatange/.m2/repository/com/relevantcodes/extentreports/2.41.2/extentreports-2.41.2.jar!/com/relevantcodes/extentreports/view/Extent.ftl"

Answer 1

Add the following dependencies in your project:

<dependency>
              <groupId>org.apache.poi</groupId>
              <artifactId>poi</artifactId>
              <version>3.10-FINAL</version>
           </dependency>


        <dependency>
             <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.10-FINAL</version>
       </dependency>