topic Re: custom Excel file output with tJavaRow in Talend Studio

custom Excel file output with tJavaRow

Anonymous — Sat, 16 Nov 2024 14:14:00 GMT

Hello,
I'm using Talend to create a job which will perform an analysis of data using multiple input (different excel files and two Oracle tables)
the goal is to generate three excel files, two of them are using the generic tFileOutputExcel component, the last one is using tJavaRow because I need to make a dynamic presentation depending on the content (I'm comparing some columns and when the result is not the expected one I put the content in RED)
It's working but my concern is that I'm opening and writing/closing the excel file for each row which make it slow. how can I create the excel file before going in the tJavaRow and closing it once it's finished (like it's done for the generic tFileOutputExcel)

Re: custom Excel file output with tJavaRow

Anonymous — Thu, 11 Sep 2008 21:37:07 GMT

Hi,
do you open the excell file yourself in tJavaRow?
If so, you can use tJavaFlex instead. There you can open, write and close the sheet in different sections. The first and last is executed only once.
Bye
Volker

Re: custom Excel file output with tJavaRow

Anonymous — Fri, 12 Sep 2008 08:15:13 GMT

thanks this is working perfectly and much faster than previously