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?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch