private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
DefaultTableModel Samplemodel = (DefaultTableModel) jTable1.getModel();
Samplemodel.setRowCount(0);
FileInputStream excelFIS = null;
BufferedInputStream excelBIS = null;
XSSFWorkbook excelImportWorkBook = null;
String defaultCurrentDirectoryPath = "D:\\Downloads";
JFileChooser excelFileChooser = new JFileChooser(defaultCurrentDirectoryPath);
excelFileChooser.setDialogTitle("Select Excel File");
FileNameExtensionFilter dist = new FileNameExtensionFilter("EXCEL FILES", "xls", "xlsx", "xlsm");
excelFileChooser.setFileFilter(dist);
int excelChooser = excelFileChooser.showOpenDialog(null);
if (excelChooser == JFileChooser.APPROVE_OPTION) {
try {
File excelFile = excelFileChooser.getSelectedFile();
excelFIS = new FileInputStream(excelFile);
excelBIS = new BufferedInputStream(excelFIS);
excelImportWorkBook = new XSSFWorkbook(excelBIS);
XSSFSheet excelSheet = excelImportWorkBook.getSheetAt(0);
for (int i = 0; i < excelSheet.getLastRowNum(); i++) {
XSSFRow excelRow = excelSheet.getRow(i);
XSSFCell excelStudentID = excelRow.getCell(0);
XSSFCell excelStudentName = excelRow.getCell(1);
XSSFCell excelCourse = excelRow.getCell(2);
XSSFCell excelYearLevel = excelRow.getCell(3);
XSSFCell excelContactNumber = excelRow.getCell(4);
XSSFCell excelBalance = excelRow.getCell(5);
Samplemodel.addRow(new Object[] {
excelStudentID,
excelStudentName,
excelCourse,
excelYearLevel,
excelContactNumber,
excelBalance
});
}
JOptionPane.showMessageDialog(null, "Your Excel File is successfully Imported");
} catch (IOException ex) {
Logger.getLogger(Sample.class.getName()).log(Level.SEVERE, null, ex);
}
}
}错误是:
线程"AWT-EventQueue-0“中的
异常java.lang.ClassCastException:无法将类javax.swing.table.DefaultTableModel转换为类示例$DefaultTableModel (javax.swing.table.DefaultTableModel位于加载程序‘引导’的模块java.desktop中;示例$DefaultTableModel位于加载程序‘app’的未命名模块中)
发布于 2022-01-25 13:19:01
它将在类DefaultTableModel中声明一个类(或接口) Sample,并且您必须导入该类而不是javax.swing.table.DefaultTableModel。
https://stackoverflow.com/questions/70848663
复制相似问题