I have an excel which contains various documents A.doc, B.pdf,C.rtf, etc. All these are stored in excel as a hyperlink to the file path. For eg. A.doc will be the text displayed in excel and the hyperlink will be ("C:\documents\Files\A.doc). There are 100 such documents in the folder, so a hundred such values(with their respective hyperlinks) in the excel column name(“FileName”)
In my program, I use specific conditions to extract certain documents only. I am doing the foll steps:
- Read range – Whole Excel into a data table dtFullFiles
- Build a new table called dtFilteredFiles
- Use Filter Data Table activity where input is dtFullFiles and the Output stored in dtFilteredFiles
- I use WriteRange to add the values of dtFilteredFiles into a new Excel
The issue I am facing is that only the filenames have got extracted to the new excel. How do I ensure that the respective hyperlinks are also transferred?