tFileExcelWorkbookSave - workbook cannot be null! error
Is it not possible to load items from a file to a context variable and pass the variable to custom component tFileExcelWorkbookSave? It works for the first pass, but then on the second row of the file I get: java.lang.IllegalArgumentException: workbook cannot be null! at de.cimt.talendcomp.tfileexcelpoi.SpreadsheetFile.setWorkbook(SpreadsheetFile.java:278)
Dear jlolling, can u keep an option in the tfileExcelWorkbooksave component, like a small check box - close workbook, which will actually save and close workbook. If the check box is not selected, the workbook should only get saved not closed and should be usable in the later point of job.
Regards
Abhi
Hi, yes it would be great. I will check that. My problem was in the past the write method from the POI API disrupts the in memory structure of the workbook and so I decided to make it unusable after saving. I will check if this problem is gone in the latest API release. To be honest I have not done this test for a year.
I will come back here next days.
Cheers