Hi
check whether it is possible to read this data.
like cardnumber, account number without hard coding.
testUipath.xlsx (11.6 KB)
Hi @KarthikBallary,
Why not? It’s nothing special in this excel file. Normal read range activity will get it without any problem and then you can use those items in loop for example.
Its possible use Read Range activity
but lot of conditions has to be put inside for each row activity ryt?
It all depends of what do you want to achieve/get from the table.
Hmm not so buddy unless we need
In for each row we will be mentioning the the datatable as input to iterate through that excel rows
And we can use conditions if we want to fetch or process a few particulate rows in them
And this excel can be read in normal read range inside the excel application scope
Cheers @KarthikBallary
if you put each row activity its read the data row by row
do you need only account related details are complete details of each row?
I want to fetch the value of
account name, aadhar, pan etc etc
Yah of course you can
Inside the for each row loop use a if condition like this
row(1).ToString.Contains(“account name”) or row(1).ToString.Contains(“Adhaan”) or row(1).ToString.Contains(“pan”)
If true it will go to THEN part where we can get them in a assign activity with string variable
Cheers @KarthikBallary
I am getting sys.data.row
as output
Ok I got it but I want value of account number. mentioned in excel sheet
yah if so inside the same IF activity with those conditions
mentioned use a ASSIGN ACTIVITY like this
str_accountnumber = row(2).ToString
Cheers @KarthikBallary
Ok thank u
can uipath be integrated with build automation(freeversion):
[quote=“Palaniyappan, post:13, topic:161784”]
row(1).ToString.Contains(“account name”)
[/quote]can we give here equals ignore case? and spaces?
suppose excel might contain “account name” or “Account name” or “Account Name” etc
then the expression be like this
row(1).ToString.ToUpper.Equals(“ACCOUNT NAME”)
Cheers @KarthikBallary
fine thank you.
Whats d diff btwn excel append range and append write range?
excel append arrange is used to add to existing data within a sheet
but write range is for adding data from a starting point or a starting cell… hope this helps.
Thanks