Six Stars

how update excel cell value

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: how update excel cell value

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

 

2 REPLIES
Six Stars

Re: how update excel cell value

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

Re: how update excel cell value

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