I have an error during reading Excel File

JAONA

• Exception: java.lang.NumberFormatException
• Message: null
• Stack trace:
• java.lang.Integer.parseInt(Integer.java:542)
• java.lang.Integer.parseInt(Integer.java:615)
• com.rapidminer.operator.nio.model.xlsx.XlsxNumberFormatParser.parseNumberFormats(XlsxNumberFormatParser.java:141)
• com.rapidminer.operator.nio.model.xlsx.XlsxResultSet.(XlsxResultSet.java:248)
• com.rapidminer.operator.nio.model.xlsx.XlsxResultSet.(XlsxResultSet.java:329)
• com.rapidminer.operator.nio.model.xlsx.XlsxSheetTableModel.(XlsxSheetTableModel.java:113)
• com.rapidminer.operator.nio.model.ExcelResultSetConfiguration.createExcelTableModel(ExcelResultSetConfiguration.java:216)
• com.rapidminer.operator.nio.model.ExcelResultSetConfiguration.createExcelTableModel(ExcelResultSetConfiguration.java:193)
• com.rapidminer.studio.io.data.internal.file.excel.ExcelSheetSelectionPanelModel$1.loadTableModel(ExcelSheetSelectionPanelModel.java:212)
• com.rapidminer.studio.io.data.internal.file.excel.ExcelSheetSelectionPanelModel$1.run(ExcelSheetSelectionPanelModel.java:176)
• com.rapidminer.gui.tools.ProgressThread$3.run(ProgressThread.java:586)
• java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
• java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
• java.lang.Thread.run(Thread.java:748)

MartinLiebig

Hi,

this should not happen. It looks like one of your integer columns has some seriously malformed data in it. I would definitely check for this or read everything as polynomial first.

Best,

Martin