This sample clears all of the hyperlink from the current worksheet. It traverses through the worksheet and if there is any hyperlink associated with the cell, it cleares the hyperlink and retains the cell value as is. Logs the time it takes to complete traversal.
Note that this only works if the cell count is < 10k
If your Excel sheet contains many hyperlinks that needs to be removed, automating that action will save time.
Checkout the script and video for more details.