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?