Using the component tFileExcelSheetOutput

Anonymous — Thu, 15 Nov 2018 14:53:43 GMT

Hi,

I would like to use the tFileExcelSheetOutput component to write data to Excel.

One of the columns should hold a hyperlink.

With the hyperlink activated (tick box) I am able to have a hyperlink in Excel.

But I would like to display in Excel a label instead of the complete link the hyperlink should link to.

How is this realized?

Kind regards,

Henk

Re: Using the component tFileExcelSheetOutput

Anonymous — Fri, 16 Nov 2018 07:00:01 GMT

Hi,

You will not be able to make the above mentioned changes using the tFileOutputExcel component.

Please remember that it is a file processing component to generate the data in a specified format. But it will not be a substitute of MS Excel for doing modifications in the data at labeling level.

If I have answered your query, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

topic Re: Using the component tFileExcelSheetOutput in Talend Studio

Using the component tFileExcelSheetOutput

Re: Using the component tFileExcelSheetOutput