Unable to read the excel data

Help
1

Hi, I am facing a while reading the excel data, Actually, I gave the email id separated with ; (semicolon) but why it’s showing an error, suppose it should read the data na.
exel data contain
image
image

How to handle this error
@Palaniyappan @ImPratham45

2

Hi
Open that excel manually
go to that cell
and right click on that cell and remove hyperlink and try reading the excel with uipath studio
Cheers @balkishan

1 Like
3

:+1::+1::+1:

4

But I want to read with given the hyperlink bro. Here I am giving multiple email in this cell, and I reading from this and sending a mail to multiple people.

@ImPratham45

5

its working for me with this statement in the writeline activity
dt.Rows(0)(0).ToString

image

image
image807×423 14.6 KB

Cheers @balkishan

1 Like
6

but my requirement is I want to give multiple email id in a cell seprated with semicolon, and then store in Variable and sending a email to multiple people. Hope you got bro

1 Like
7

in your case try with this statement buddy
dt.Rows(0)(1).ToString
where the actuall syntax is
yourdatatablename.Rows(rowindex)(columnindex)

Cheers @balkishan

1 Like
8

If the Index is changed, Can we give the Column name also, will it work. ?

9

yah of course it will
Cheers @balkishan

1 Like
10

so doing this can I store a value in a variable,

will it store all the email ID separated with comma in a variable ?

1 Like
11

yah it would

image
image875×454 17.1 KB

@balkishan

1 Like
12

yes you can store them into a variable

13

But it’s showing me an error bro, same i did see

image

@ImPratham45 @Palaniyappan

1 Like
14

use EXCEL APPLICATION SCOPE and READ RANGE within it and the syntax is
dt.Rows(0)(1).ToString
as the read range would have first row as header right

@balkishan

1 Like
15

is it working now
@balkishan

16

Thanks @Palaniyappan @ImPratham45

17

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