topic tfileexcelsheetoutput append data and apply existing formulas to appended rows in Talend Studio

tfileexcelsheetoutput append data and apply existing formulas to appended rows

Anonymous — Wed, 29 Nov 2017 11:00:31 GMT

Hi there,

I am using tfileexcelsheetoutput and appending data rows from a csv to an excel sheet and I want the existing formulas in the excel sheet to cascade down and be applied to all appended data

has anybody got a way to do this? see below for how component is configured:

Re: tfileexcelsheetoutput append data and apply existing formulas to appended rows

Anonymous — Thu, 30 Nov 2017 03:12:08 GMT

Hello,

The tFileExcelSheetOutput component is a custom component written by talend community user and shared on talend support portal.

Feel free to contact the author please.

Best regards

Sabrina