tFileExcelSheetInput throws a null pointer exception

One Star

tFileExcelSheetInput throws a null pointer exception

Hi,
I liked the features of the tFileExcelSheetInput and tFileExcelWorkbookOpen.
I run a few test with it before replacing the standard excel components and for the first runs all was working fine.
Then I don't know exactly what triggered it but I started getting a NullPointerException see stacktrace:
Are there any classpath dependencies I need to worry about? does anyone know where can I get the source code for superclass of tFileExcelSheetInput?
Exception in component tFileExcelSheetInput_1
java.lang.NullPointerException
at de.cimt.talendcomp.tfileexcelpoi.SpreadsheetInput.configColumnPositions(SpreadsheetInput.java:605)
at apriroiservices.exceltoloadfunctionintoproject_2_0.ExcelToLoadFunctionIntoProject.tFileExcelWorkbookOpen_1Process(ExcelToLoadFunctionIntoProject.java:15884)
at apriroiservices.exceltoloadfunctionintoproject_2_0.ExcelToLoadFunctionIntoProject.runJobInTOS(ExcelToLoadFunctionIntoProject.java:20512)
at apriroiservices.exceltoloadfunctionintoproject_2_0.ExcelToLoadFunctionIntoProject.runJob(ExcelToLoadFunctionIntoProject.java:20254)
at apriroiservices.readloadfunctionintoprojectmessage_1_0.ReadLoadFunctionIntoProjectMessage.tFileInputXML_1Process(ReadLoadFunctionIntoProjectMessage.java:6751)
at apriroiservices.readloadfunctionintoprojectmessage_1_0.ReadLoadFunctionIntoProjectMessage.runJobInTOS(ReadLoadFunctionIntoProjectMessage.java:7305)
at apriroiservices.readloadfunctionintoprojectmessage_1_0.ReadLoadFunctionIntoProjectMessage.runJob(ReadLoadFunctionIntoProjectMessage.java:7002)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.tRunJob_3Process(RequestDispatcher.java:2166)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.tFileInputXML_1Process(RequestDispatcher.java:1301)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.runJobInTOS(RequestDispatcher.java:6314)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.runJob(RequestDispatcher.java:6115)
at apriroiservices.folderdatasource_1_1.FolderDatasource.tJava_1Process(FolderDatasource.java:893)
at apriroiservices.folderdatasource_1_1.FolderDatasource.runJobInTOS(FolderDatasource.java:1303)
at apriroiservices.folderdatasource_1_1.FolderDatasource.runJob(FolderDatasource.java:1115)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.tRunJob_1Process(LoadFunctionIntoProjectService.java:741)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.tJava_1Process(LoadFunctionIntoProjectService.java:526)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.aPrioriProperties_1Process(LoadFunctionIntoProjectService.java:422)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.runJobInTOS(LoadFunctionIntoProjectService.java:1024)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.main(LoadFunctionIntoProjectService.java:870)
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at apriroiservices.readloadfunctionintoprojectmessage_1_0.ReadLoadFunctionIntoProjectMessage.tFileInputXML_1Process(ReadLoadFunctionIntoProjectMessage.java:6781)
at apriroiservices.readloadfunctionintoprojectmessage_1_0.ReadLoadFunctionIntoProjectMessage.runJobInTOS(ReadLoadFunctionIntoProjectMessage.java:7305)
at apriroiservices.readloadfunctionintoprojectmessage_1_0.ReadLoadFunctionIntoProjectMessage.runJob(ReadLoadFunctionIntoProjectMessage.java:7002)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.tRunJob_3Process(RequestDispatcher.java:2166)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.tFileInputXML_1Process(RequestDispatcher.java:1301)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.runJobInTOS(RequestDispatcher.java:6314)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.runJob(RequestDispatcher.java:6115)
at apriroiservices.folderdatasource_1_1.FolderDatasource.tJava_1Process(FolderDatasource.java:893)
at apriroiservices.folderdatasource_1_1.FolderDatasource.runJobInTOS(FolderDatasource.java:1303)
at apriroiservices.folderdatasource_1_1.FolderDatasource.runJob(FolderDatasource.java:1115)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.tRunJob_1Process(LoadFunctionIntoProjectService.java:741)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.tJava_1Process(LoadFunctionIntoProjectService.java:526)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.aPrioriProperties_1Process(LoadFunctionIntoProjectService.java:422)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.runJobInTOS(LoadFunctionIntoProjectService.java:1024)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.main(LoadFunctionIntoProjectService.java:870)
Exception in component tRunJob_3
java.lang.RuntimeException: Child job running failed
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.tRunJob_3Process(RequestDispatcher.java:2190)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.tFileInputXML_1Process(RequestDispatcher.java:1301)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.runJobInTOS(RequestDispatcher.java:6314)
at apriroiservices.requestdispatcher_1_3.RequestDispatcher.runJob(RequestDispatcher.java:6115)
at apriroiservices.folderdatasource_1_1.FolderDatasource.tJava_1Process(FolderDatasource.java:893)
at apriroiservices.folderdatasource_1_1.FolderDatasource.runJobInTOS(FolderDatasource.java:1303)
at apriroiservices.folderdatasource_1_1.FolderDatasource.runJob(FolderDatasource.java:1115)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.tRunJob_1Process(LoadFunctionIntoProjectService.java:741)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.tJava_1Process(LoadFunctionIntoProjectService.java:526)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.aPrioriProperties_1Process(LoadFunctionIntoProjectService.java:422)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.runJobInTOS(LoadFunctionIntoProjectService.java:1024)
at apriroiservices.loadfunctionintoprojectservice_2_0.LoadFunctionIntoProjectService.main(LoadFunctionIntoProjectService.java:870)
One Star

Re: tFileExcelSheetInput throws a null pointer exception

The issue is that a sheet with the sheet-name existed but the sheet itself was empty. no rows.
Would be nice if the code checked for this scenario and gave a better error message.