where skill =‘HTML’ or skill=‘Java’ . The ‘HTML’ and ‘Java’ keywords is depended on the user input and skill is another column name
Can u Share the screenshot of that filter activity?
Did u put anything in output columns section?
@NIVED_NAMBIAR . The column DocName needs to have the link
Here is an activity called extract hyperlink from BalaReva.EasyExcel package . it extracts the hyperlink , display and colinfo.
Input format :
if you know the cell range , you can give like this “A2:A4”
ExtractHyperLink.zip (39.7 KB)
Hi @Purnima_Sambasivan check this below.
I had used linq query here
text_file.zip (1.4 MB)
Hope it helps
Hello Sir, thank you so much for this. I use your products regularly and it has helped me solve many things, especially wrt excel graphs. For Hyperlink also I have used it.
For the example you have given, I need the same contents copied to another sheet (along with the hyperlink). When I do that only the text is getting copied and not the hyperlink (Please note I don’t need the hyperlink as a separate column)
When I copy the DocName column into another sheet, only the name is getting transferred and not the hyperlink. Hope I am clear
Thanks for the response, Sir.
@NIVED_NAMBIAR Thank you for the guidance. I think I was not clear in my question. Please refer to my comments above and suggest solution. Thanks again!
Your requirement is very interesting.
As of my understanding,
- I think you need to use the above mentioned balareva package, to get the links addresses first.
- Then write the links to the output file as normal text.
- Now need to perform UI Automation on the output file, to make normal text form of links to hyper links.
Thanks and Regards.
It may help you…
There is an activity called “Add Hyperlink from Datatable” from BalaReve.Excel package.
Here I have attached the sample that it copies (Sheet1) the hyperlink data into a datatable. After It will transform the data table to a hyperlink source and write in the excel sheet2.
Here is the sample :
ExtractHyperLink.zip (41.0 KB)
Final output from sheet2:
I had tried your query and had got it.
I had used the combination of excel + @balupad14 balareva activities.
The logic i had used here.
Read the excel file and store in dt1.
use extract hyperlink activity from balareva easy excel activity and extract the hyperlink and stored in a datatable dt2 which contains Display text, url, cell address as column .
The dt2 is like as below.
(i had displayed as for ur reference).
Filter the datatable dt1 as per the below linq query ( I had filtered for skills either java or HTML for demonstartion)
dt1 = dt1.AsEnumerable().Where(Function® r(“Skill”).ToString.Equals(“Java”) or r(“Skill”).ToString.Equals(“HTML”)).CopyToDataTable
after the extract hyperlink activity use write range activity to write the filtered dt1 into the sheet2.(filtered as per the step3)
Then loop through each row in filtered dt1 using for each row and find find corresponding url in dt2 using lookup datatable activity and add that link to the display text using Insert Hyperlink activity (from Balareva.EasyExcel Activities)
This is the entire logic i applied.
So i had used input file as below
Output i got
Check the attached workflow
text_file.zip (1.4 MB)
Hope it helps
Thanks for this nice question
Thanks @balupad14 for this nice excel actvity.
Wow… worked like a breeze. Thank you Nived. 2 things –
- I used the Filter Data table instead of enumerable
- The process of just getting a link in a round about way is slowing down my process. Wish there was a way where I can directly transfer the URLs also from the excel when we transfer the contents from the excel to the data table
Really grateful for the guidance.
Bala Sir, this is an amazing feature. Thank you so much. Solved most of my problem but for this. When I send this excel via email to someone and they download it, it is giving a relative path to the document instead of the absolute path.
For eg. If Revathi.doc is an hyperlink to the D:\UiPath\Documents\Revathi.doc, then when any user downloads this excel from their machine, this is getting converted to the link C:\Users\Uipath\Documents\Revathi.doc and when I click on it , it says “Specified file is not found”. I would like to retain the absolute path. Any suggestions for it?
Another way would be invoking the c# code in Uipath which does these
Thank you @Purnima_Sambasivan. I noted the point. in future releases, I will add this one. ~
Wow, thank you Sir, that would be so useful!
OK. Good to know. Should try that option also
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.