'From list to Excel on Talend

I have a tJavaFlex on Talend which produces a list of values ​​and I would like to write these values ​​in an Excel file.

Here is my job :

enter image description here

My tJavaFlex code is:

// start part of your Java code
java.util.ArrayList<row5Struct> list = new java.util.ArrayList<row5Struct>() ; 

// here is the main part of the component,
// a piece of code executed in the row
// loop
row5Struct row_new = new row5Struct();

row_new.date = row5.getDate();
row_new.id = row5.getId();
row_new.total = row5.getTotal();

list.add(row_new) ;

// end of the component, outside/closing the loop
int n = 1 ;
for(int i=0 ; i<list.size() ; i++)
{
     // an algorithm that modifies the list and deletes some rows
}

How can I send values from a list on tJavaFlex to an Excel file ?

If there is another way to retrieve SQL data by deleting and modifying some lines I am also taker.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source