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
How to handle this error
@Palaniyappan @ImPratham45
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
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.
its working for me with this statement in the writeline activity
dt.Rows(0)(0).ToString
Cheers @balkishan
1 Like
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
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
If the Index is changed, Can we give the Column name also, will it work. ?
yah of course it will
Cheers @balkishan
1 Like
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
1 Like
yes you can store them into a variable
1 Like
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
1 Like
is it working now
@balkishan
Thanks @Palaniyappan @ImPratham45
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.