topic Re: how update excel cell value in Talend Studio

how update excel cell value

JaneYu — Wed, 18 Apr 2018 22:11:49 GMT

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 — Wed, 18 Apr 2018 22:14:30 GMT

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

JaneYu — Thu, 19 Apr 2018 21:39:08 GMT

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