-
July 7th, 2021, 04:19 AM
#1
NoClassDefFoundError trying to read Excel File
Wrote this program in Eclipse. DOwnloaded POI 5.0.0 and added it to library by Project->Properties->Java Build Path->Libraries->Added poi-5.0.0.jar and poi-ooxml-5.0.0.jar under classPath. I then get errr NoClassDefFoundError from this line:
HTML Code:
workbook = new XSSFWorkbook(excelBIS);
My entire code:
HTML Code:
JButton btnBrowse = new JButton("Browse File");
btnBrowse.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
//Definitions
//=========Action here==========
File excelFile;
FileInputStream excelFIS = null;
BufferedInputStream excelBIS = null;
XSSFWorkbook workbook=null;
//Default Path
String defaultPath = "C:\\Users\\Philip Chen\\Documents\\dermaGrapher.xlsx";
JFileChooser fileChooser=new JFileChooser(defaultPath);
int excelChooser=fileChooser.showOpenDialog(null);
//Open Button Clicked
if(excelChooser==JFileChooser.APPROVE_OPTION)
{
try
{
excelFile=fileChooser.getSelectedFile();
excelFIS=new FileInputStream(excelFile);
excelBIS=new BufferedInputStream(excelFIS);
workbook = new XSSFWorkbook(excelBIS);
XSSFSheet excelSheet = workbook.getSheetAt(0);
//Loop through excel columns and rows
for(int row=0;row<10;row++)
{
XSSFRow excelRow=excelSheet.getRow(row);
XSSFCell excelName = excelRow.getCell(0);
XSSFCell excelDate = excelRow.getCell(1);
XSSFCell excelScore = excelRow.getCell(2);
XSSFCell excelOil = excelRow.getCell(3);
XSSFCell excelHydration = excelRow.getCell(4);
XSSFCell excelMelanin = excelRow.getCell(5);
XSSFCell excelOxygen = excelRow.getCell(6);
XSSFCell excelRedness = excelRow.getCell(7);
model.addRow(new Object[]{excelName, excelDate, excelScore, excelOil, excelHydration,excelMelanin,excelOxygen,excelRedness});
}
}catch(FileNotFoundException ex)
{
JOptionPane.showMessageDialog(null, ex.getMessage());
}catch(IOException ex)
{
JOptionPane.showMessageDialog(null, ex.getMessage());
}finally {
try {
if (excelFIS != null) {
excelFIS.close();
}
if (excelBIS != null) {
excelBIS.close();
}
if (workbook != null) {
workbook.close();
}
} catch (IOException iOException) {
JOptionPane.showMessageDialog(null, iOException.getMessage());
}
}
}
//End of function
}
});
Any help is appreciated! I am desperate, Thanks!
-
July 7th, 2021, 02:06 PM
#2
Re: NoClassDefFoundError trying to read Excel File
Please copy the full text of the error message and paste it here.
Is the missing class in a jar file that is on the classpath when the program is executed.
Also posted here: https://www.javaprogrammingforums.co...tml#post172148
Norm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|