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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog