Eclipse Community Forums: Java Development Tools (JDT)

Help

Home

Home » Language IDEs » Java Development Tools (JDT) » ClassNotFoundException

Show: Today's Messages :: Show Polls :: Message Navigator

ClassNotFoundException [message #1817850]

Sun, 01 December 2019 05:00

Jessica Hop

Messages: 1
Registered: December 2019

Junior Member

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public void ReadXL(String Path) throws Exception
{
FileInputStream myStream=null;

System.out.println("InReadxl");
File xlFile = new File(Path);

myStream = new FileInputStream(xlFile);
HSSFWorkbook myWB = new HSSFWorkbook(myStream);

...........................

}

HSSFWorkbook myWB = new HSSFWorkbook(myStream); is creating
ClassNotFoundException() after adding external jar file
"poi-3.7-20101029".What might be causing the prolem?Please,let me know
the soultion of this problem.

Thanks

Report message to a moderator

Re: ClassNotFoundException [message #1817960 is a reply to message #1817850]

Tue, 03 December 2019 15:27

Eitan Rosenberg

Messages: 149
Registered: October 2018

Senior Member

- If you can try to use xlsx files and then you can use XSSF (See https://poi.apache.org/)

- I am using Maven and I have those dependencies (jars....)

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

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-scratchpad</artifactId>
<version>4.1.1</version>
</dependency>

Some code:

package examples;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class Main {

public static void main(final String[] args) {
new Main();
}

public Main() {

try (FileInputStream myStream = new FileInputStream(new File("H:/Temp/MyTemp.xls"));
final HSSFWorkbook hssfWorkbook = new HSSFWorkbook(myStream);) {

final HSSFSheet hssfSheet = hssfWorkbook.getSheet("Sheet1");

final HSSFRow hssfRow = hssfSheet.getRow(0);

final HSSFCell hssfCell = hssfRow.getCell(1);

System.out.println(hssfCell);

} catch (final IOException exception) {
exception.printStackTrace();
}

}

}

This works for MyTemp.xls