Read excel in specfic format

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.

1 Like

Its possible use Read Range activity

1 Like

but lot of conditions has to be put inside for each row activity ryt?

Yes u can use read range to read the contents.

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

1 Like

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

1 Like

Ok thank u

can uipath be integrated with build automation(freeversion):

hmm…not sure havent tried… but i hope we wont be able to
@KarthikBallary

[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?

hi @KarthikBallary

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