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

Help
1

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:

image
image823×254 10 KB

@loginerror @Palaniyappan

1 Like
2

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

2 Likes
3

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

image
image892×493 16 KB

1 Like
4

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

2 Likes
5

see it containing value bro.

image
image813×479 15.2 KB

@lakshman

1 Like
6

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

2 Likes
7

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
8

but it looks something different here in write cell

“E”+Row…

image

@balkishan

1 Like
9

Try once using TrimItem.toString

2 Likes
10

This is fine bro.
image

2 Likes
11

same issue after giving write the TrimItem.tostring.

Even the TrimItem contain the value.

image
image824×333 12.4 KB

@Palaniyappan

1 Like
12

Try printing the “E”+row…

2 Likes
13

@balkishan

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

1 Like
14

Everything is fine bro.

image
image810×450 15.5 KB

@lakshman

1 Like
15

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

2 Likes
16

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

image

image

1 Like
17

Can you send the xaml file

1 Like
19

@balkishan

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

2 Likes
20

That’s what I wonder bro.

1 Like
21

CAN YOU SIMPLY TRY TO WRITE A HARDCODED VALUE TO THAT

2 Likes