Excel convert field value to hyperlink in output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Someone please help me with the following.
I have a flow, in which I get an excel file as output, one of the column has the path, but as string.
Is there way to make it hyperlink when creating excel itself?
File path |
\\manoj90101\proro\oirriit\ |
I want it to be an hyperlink when I open excel, not as string.
Please help
Thanks In advance
Solved! Go to Solution.
- Labels:
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The user of the excel has to enable DDE , by which excel will auto enable any string or text that is present in the workbook as a hyper link. User can hold Ctrl + Click to navigate to the location. This may however not work withany Intranet , FTP location within your internal network.
The link for Microsoft's forum is below :
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It is possible to do this directly in Alteryx by using the reporting tools.
The 'Text' tool in the reporting suite allows you to create a hyperlink, we can then bring this together using the table tool (and apply any formatting you want), and then use the 'render' tool to output this as an .xlsx output.
I've attached a working example for you.
It's not possible to do this with the standard output tool, unless you get your users to mess around with their excel configuration as the user above says.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot, Ben. It worked without any issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
May i know if you were able to resolve this issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have similar case where attached is the input excel file where column document name and document number is having hyperlink attached to it. Need help in related to how to retain hyperlinks in those two column in the output excel file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, have you found a solution for this?
