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

Hi, I am updating the excel but I am getting an error while updating it, so can you please tell me is there any limitation of Studio that we can’t update the excel if it has to contain hyperlinks data like
abc@gmail.com;xyz@hotmail.com

Error is:

@loginerror @Palaniyappan

1 Like

Hi
kindly try with EXCEL APPLICATION SCOPE with WRITE CELL in it
@balkishan

2 Likes

Same error I am getting when I use the Write Cell activity inside the Excel Scope.

1 Like

this time not with respect to HYPERLINK
but the value of TrimItem is null kindly check that once
@balkishan

2 Likes

see it containing value bro.

@lakshman

1 Like

Fine
what is the range mentioned out there in the cell
Cheers @balkishan

2 Likes

A2 bro Bcz I have to read always from the A2. I don’t need the First line. My header is from A2 only.
see the template structure,
image

image

1 Like

but it looks something different here in write cell

"E"+Row…

image

@balkishan

1 Like

Try once using TrimItem.toString

2 Likes

This is fine bro.
image

2 Likes

same issue after giving write the TrimItem.tostring.

Even the TrimItem contain the value.

@Palaniyappan

1 Like

Try printing the “E”+row…

2 Likes

@balkishan

In Write Cell activity, what range you mentioned ? And also have you initialized RowNum variable or not ?

1 Like

Everything is fine bro.

@lakshman

1 Like

Then it should definitely write. The Sheet Name is proper right?

2 Likes

Same sheet I am reading and In same I am updating/writing bro

image

image

1 Like

Can you send the xaml file

1 Like

@balkishan

Every thing looks correct only. But why it is giving Object reference error :frowning: :frowning:

2 Likes

That’s what I wonder bro.

1 Like

CAN YOU SIMPLY TRY TO WRITE A HARDCODED VALUE TO THAT

2 Likes