how update excel cell value

[JaneYu]

There is a talend job getting data from hadoop hive table and outputting to an excel file.

The excel output file: 

Row 1- cell A1 = Process Date

Row2- is the column headers

How to update the cell A1 in the output file dynamically with the process date? Thank you.

[JaneYu]

the process date is a context variable which is passed from jams job.

[JaneYu · Accepted solution]

Jan Lolling's Custom components- tFileExcel components solved my problem.

Here is how it works

1. name cell A1= Process_date in the excel template

2. go to talend and use  tFileExcelNamedCellOutput after tFileExcelSheetOutput and before tFileExcelWorkBookSave

configure the cell output:

cell name                      Value

"process_date"          context.ProcessDate