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

Hi All,

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

Hi @nidhia68

You would have to write it cell by cell. Even if you have placed the formula in the datatable.
You would have to specifically write that column separately looping it cell by cell.

or else if it is being written basis on some existing data from your datatable, you can write the formula in first cell of the column and Use Auto Fill.

Happy Automation!

Hi,

You could use Hyperlink function in a cell and then autofill in the entire range. This will ocmvert your URL to a hyperlink.
How to Use Excel HYPERLINK Function (8 Examples) - ExcelDemy

Formula: =HYPERLINK(Cell Reference)

Thanks.

@adiijaiin

Actually scenario is:
I have to update the datarow with some text value so the starting and ending is a simple string and in between we have hyperlink

Example: output is “text1”+ hyperlink+“text2”

Also the cell value is not fixed and it’s not compulsory that every cell will have hyperlink in datatable.

Can you showcase your expected output in excel file?