I had performed data scrapping to capture data from webpage and saved it in the excel sheet. each column has a header name, and the header with the name URL needs to be changed. As the name suggests the URL header contains url of a specific page, i wish to add “www.linkedin.com” before each url that is there in the sheet
In my workflow i was able to capture each url and after attaching “www.linkedin.com” i saved it in a variable named as “secondurl” but i am not getting the idea how to replace it with the old one. Can anyone please help me
@Hemanth Thanks for the reply, your workflow is replacing the old url with the new one, but the first url is getting replaced as “www.linkedin.com/URL” can you please give it a look
Currently I have an excel sheet that has a data like this
> Position URL Company Location
> Develope /xyz/123/xyz ABC US
> Manager /xyz/132/asd ASD US
> Tester /xyz/142/asf ABD US
I wish to capture all the url from this sheet and add “www.linkedin.com/” before them and replace the old url with the new url so that the sheet becomes like this
Position URL Company Location
Developer www.linkedin.com/xyz/123/xyz ABC US
Manager www.linkedin.com/xyz/132/asd ASD US
Tester www.linkedin.com/xyz/142/asf ABD US
Your workflow is doing this task but is doing from the second url, so through your workflow i am getting output like this
Position URL Company Location
Developer www.linkedin.com/URL ABC US
Manager www.linkedin.com/xyz/132/asd ASD US
Tester www.linkedin.com/xyz/142/asf ABD US
Hope I was able to clear the concept through this example
Thanks, it is working but there is one thing, in present sheet there are 5 entries so the sheet is getting opened and close for 5 times, i will be having more than 500 entries in a sheet. will it be better to open the sheet once and do all the changes and then close it rather than opening and closing it for 500+ times
@samya,
In Excel Application Scope there is a option called Visible
If the option is Enable the excel application will open and close.
Suppose it will disable the excel application will not open for everytime…