Hi Team, I have a DataTable DT1 with two columns: URL and Keyword, and a Master Sheet with the same columns. I need to: Append the rows from DT1 to the Master Sheet. Format only the newly appended rows by: Converting the text in the URL column to clickable hyperlinks. Applying red font color t…

[image] Vaishnavi_R: Converting the text in the URL column to clickable hyperlinks. hi @Vaishnavi_R you can refer below thread on same. [image] Hyperlink the Link present in Datatable Studio @Goku You can add a formula like this to each row using expression Dt.C…

Try below steps Open Excel File Identify the last row in the excel file using Find First/Last Data Row activity Loop through the data table Add count with the last row Use write cell activity Use formula “=HYPERLINK(”“” & CurrentRow(“Column1”).ToString & “”“, “”” & CurrentRow(“Column1”).ToString & …

Thanks You. I used your workflow ,it’s successfully converting the link into a clickable URL. But, after I added the Format Cell activity to change the font color to red, the hyperlink is reverting back to plain text. Do you have any idea why this might be happening?

Hi Vaishnavi, Need to check on that. Is it mandatory to change the links to red color or it it okay to change the cell color as red Normally links are maintained in the same format only just checking to see the importance of requirement

As I am appending data to the master file, it is necessary to change the cell color of columns A and B to red for better readability.

In that case- It is better to use VBA for changing the font color. Format cells might change the existing properties of the cell Use the updated file where i have created the VBA file and included invoking the same as well EmailScenarios.zip (148.5 KB) <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/d/3/a/d3ae8b9a89f5b236f28731703fa9960804aed2cb.png" data-download-href="/uploads/short-url/ucCHTb3nOEDU8f32JDeZkc8M4YP.png?dl=1" title="This image depicts a flowchart outlining an automation process in a software application to manipulate an Excel file by building a data table, iterating over rows, writing hyperlinks to cells, selecting a range, and invoking VBA code to modify cell fonts. (Captioned by AI)">[This image depicts a flowchart outlining a…

Convert Excel Cell Values to Clickable Hyperlinks

Help Studio

sharazkm32 (Sharaz K M) May 25, 2025, 2:21pm 7

In that case- It is better to use VBA for changing the font color. Format cells might change the existing properties of the cell

Use the updated file where i have created the VBA file and included invoking the same as well

EmailScenarios.zip (148.5 KB)

Topic		Replies	Views
Hyperlink the Link present in Datatable Studio studio , question , activities_panel	6	1304	April 23, 2024
How to write string as hyperlink in excel Studio studio , question	9	532	April 17, 2024
How to add hyperlink in a datarow and then write datatable to excel....when I am trying to add it's coming a normal text in output Excel file instead of hyperlink Studio	4	665	June 13, 2023
Please help me with Excel hyperlinks Studio studio , question	15	1398	August 21, 2023
Ways to add a hyperlink to cells in excel without using Write cell/write range excel activities? Studio datatable , excel , uiautomation , studio , question , activities_panel	9	1428	April 19, 2023

Convert Excel Cell Values to Clickable Hyperlinks

Related topics