How to change a particular column of an excel sheet

excel
uiautomation
activities

#1

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

Main.xaml (8.1 KB)
test.xlsx (8.6 KB)


#2

Hi,
I hope this will helpful to You…
attach.xaml (9.7 KB)

Regards,


#3

@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


#4

@samya,
Sorry i can’t get You…
Plz…Explain briefly…

Regards,


#5

@Hemanth

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


#6

@samya,
I think you have to enable Add header check box of Read Range in properties Panel…

Regards,


#7

@Hemanth Did that but still not getting the desired result


#8

@samya,
Send ur final workflow…


#9

Hi, @samya

This is my output:

Regards,


#10

@samya,
Try this flow…
particular value in excel.xaml (13.2 KB)
Particular value in excel.xlsx (8.5 KB)


#12

@Poovarasan2 I am getting the error Assign : Column ‘URL’ does not belong to table


#13

Follow what @Hemanth says,


#14

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


#15

It worked had a little error from my end, Thanks a lot


#16

@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…

Capture

Regards,


#17

It worked nicely, Thanks a lot