How to input value from Excel to Xaml as type into?

Help Studio
1

How to input value from Excel to Xaml as type into?

example) I input “5” in excel, then “5” could be input to XAML as type into

2

@Lee_Yuwan

Welcome to forums

Use Read Range activity-> Give path of your Excel File
Use For Each Row to iterate into datatable
Create a variable which can store the excel value

For your reference, you can check as below for videos

Also this with different usecase

Hope this helps you

Thanks

1 Like
3

Hi @Srini84, may I ask you a question?

I have 3 excel sheets in the same workbook. With the same item but different numbers.

All the 3 sheets have two column and heading cell - A1 “Item”, B1 “Number”.

Sheet 1- (A1:A6) “Name” “Coke”, “bread”, “Sausage”, “Biscuit”, “Apple” (B1:B6) “Number” “2”, “8”, “8”, “3”, “6”.

Sheet 2- (A1:A6) same item as Sheet 1 (B1:B6) “Number”, “6”, “0”, “5”, “5”, “5”.

Sheet 3- (A1:A6) same item as sheet 1 (B1:B6) “Number”,
“0”, “3”, “4”, “7”, “7”.

I have to calculate the total of each item in the 3 execl sheet and auto fill into google form using UI path.

Q1.How many bottle of coke?

Q2. How many slices of bread?

Q3. How many sausages?

Q4. How many pieces of biscuits?

Q5. How many apples?