Is there limitation of the studio that we can't update the excel if it has hyperlink

RemoveWhiteSpace.zip (2.9 KB)

Please check bro

1 Like

where bro? In excel ?

1 Like

yea same write cell just change trimitem to “trimitem”

2 Likes

Sorry for the delay
Kindly use WRITE CELL with same inputs inside the EXCEL APPLICATION SCOPE and try once
Cheers @balkishan

2 Likes

you want me like this ?
image

previously I was using the same bro

1 Like

I did the same bro, Even I shared the worklfow also see in the last comment. But Error is getting Object Refrence.

2 Likes

Tried not working. :frowning:

1 Like

“VendorMaster.xlsx”

2 Likes

Means ?

1 Like

working…?

2 Likes

Not woring, still the issue is there showing an Object Reference issue…please check the last comments

1 Like

Hi @balkishan,

I see no problem this exemple is from excel to excel. becouse on web with data scrap you get url in auto

Read Hyperlink

Write Hyperlink

1 Like

what is this, I am not getting any data from web scrapping.

Please read the last comments then you will know what is the issue here. Hope you understand buddy.

1 Like

Yes i understand you if you see the print only show excel files no web

1 Like

I think you didn’t get the issue bro.

2 Likes

Hi @Palaniyappan @lakshman can you reply on this issue ?

2 Likes

Can you try removing that close workbook activity @balkishan? I hope it is closing the excel and then you are trying to write the value which will give you the error

2 Likes

sorry for the delayed response

i got it
here you go
i just recreated it
its working fine

bal.zip (37.0 KB)

Cheers @balkishan

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.