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

Lee_Yuwan · February 20, 2021, 11:21am

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

Srini84 · February 20, 2021, 2:08pm

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

H_YL · May 12, 2021, 1:54pm

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?