NullPointerException on ExcelOutput

One Star

NullPointerException on ExcelOutput

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!
One Star

Re: NullPointerException on ExcelOutput

You could try to check the option Append Existing File.
One Star

Re: NullPointerException on ExcelOutput

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?