I am reading an excel file like below using poi3.6 jars
commons-collections4-4.1.jar
commons-collections4-4.1-javadoc.jar
commons-compress-1.18.jar
poi-3.16.jar
poi-examples-3.16.jar
poi-excelant-3.16.jar
poi-ooxml-3.16.jar
poi-ooxml-schemas-3.16.jar
poi-scratchpad-3.16.jar
FileInputStream file = new FileInputStream(new File('D:\\sample.xls'));
XSSFWorkbook workbook1 = new XSSFWorkbook(file)
XSSFSheet sheet1 = workbook1.getSheetAt(0)
Iterator ite = sheet1.rowIterator();
But always getting the error like
Is there any other easy method of reading from an excel. Pplease help.
Solved! Go to Solution.
Please use ooxml-schemas-1.3.jar and try again.
Don't forget to accept as solution and give kudos.
Please use ooxml-schemas-1.3.jar and try again.
Don't forget to accept as solution and give kudos.
Thank you it worked
I will try this also
Subject | Author | Latest Post |
---|---|---|