Eplace entries in an excel without using a Data Table

Hello friends,

my goals ist to replace entries in an excel without using a Data Table.

In these cells we have names of files stored as links. As I can retrieve the HyperLink now with the usage of BelaReva Activity package I need to do the following:

– Loop trough the cells:
–> Extract from each cell in column N the hyperlink behind this text.
–> Replace the text in Column N with this Hyperlink.

I cannot use a data table because as soon as I load the Excel into the data table, I only find the names of the files in the data table and not the hyperlinks.

So there I start losing information and have to manage it before in Excel.

Some suggestions here how to manage this effectively?

Many thx.