tFileOutputExcel won't overwrite a worksheet

[welshsteve]

Hi.

I have an xlsx Excel file with various worksheets in them.

I am creating a Talend job which feeds data into these worksheets.

What I need the job to do is overwrite the worksheet if it already exists each time the job is run.

Job Design is:

tDBInput >> tMap >> tFileOutputExcel

It doesn't seem to matter what options I pick in the tFileOutputExcel component, each time I run the job, I get the error The workbook already contains a sheet named 'ref_annuity_type'

The options in the component seem very limited, with no apparent option to overwrite the sheet. Can this not be done?

There also doesn't appear to be an option to truncate all the data in the worksheet first before re-populating.

Many thanks in advance.

Steve

[Anonymous · Accepted solution]

Hello,

Please check "Append existing file", and check "Append existing sheet" in your tFileOutputExcel component to add the new lines both at the end of the file and the end of the Excel sheet.

Feel free to let us know if it helps.

Best regards

Sabrina