topic Re: NullPointerException on ExcelOutput in Talend Studio

NullPointerException on ExcelOutput

Anonymous — Sat, 16 Nov 2024 13:24:13 GMT

Hello!
I use TOS 4.0.0.M3_r37054.
At first I copy a File with a dynamic Filename. Then I take the data from my Oracle-DB an want to put it in an Excelfile.
If the Excel-File is empty, there is no problem. But if the excel file has some content, there comes that error:
Exception in component tFileOutputExcel_1
java.lang.NullPointerException
at jxl.write.biff.File.write(File.java:130)
at jxl.biff.ConditionalFormat.write(ConditionalFormat.java:106)
at jxl.write.biff.SheetWriter.write(SheetWriter.java:566)
at jxl.write.biff.WritableSheetImpl.write(WritableSheetImpl.java:1408)
at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:856)
...
Please help!

Re: NullPointerException on ExcelOutput

Anonymous — Tue, 08 Jun 2010 04:10:26 GMT

You could try to check the option Append Existing File.

Re: NullPointerException on ExcelOutput

Anonymous — Tue, 08 Jun 2010 07:36:52 GMT

Thanks for your replay.
I solved the problem.
But it is a very bad solution. In my excel-file were some conditional formattings.
TOS couldn't handle with them. Is there a way to write in an EXCEL-File with conditional formattings?