Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-11-15 09:53 AM

Using the component tFileExcelSheetOutput

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

Labels (1)
Labels

  • v7.x

231 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-11-16 02:00 AM
Author

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

231 Views
0 Likes