Use excel values using variable?

[darpan.sharma]

Hi all, I am making a robot that captures data from excel sheet and enters into a java application - working fine.
Now that excel sheet has many values and I am told to use variables so it can pick values from excel. I have never used it, can someone help ?

[furkan.cosan]

Hi @darpan.sharma,

To capture values from each column in your Excel sheet and use them in your process, you can follow these steps:

• Create Variables for Each Column: Define a variable for each column you want to capture (e.g., ICCID, FirstName, LastName).
• Use ‘Assign’ Activity to Set Values: Inside the For Each Excel Row loop, use the ‘Assign’ activity to set each variable’s value. For example, ICCID = CurrentRow("ICCID").ToString, FirstName = CurrentRow("First").ToString, and so on. This will assign the cell values to your variables.
• Use Variables in Your Workflow: Now you can use these variables in your workflow to enter data into your Java application.

This approach should help you work with each row’s data more easily. Let me know if you need further assistance!

Regards

[Anil_G (Anil Gorthi)]

@darpan.sharma

What you are doing is correct…just increase the value 0 to 1,2,3 based on which column you need

cheers

[darpan.sharma]

Can you please check why condition on range is not working ?

[Anil_G (Anil Gorthi)]

@darpan.sharma

Can you please tell what that condition means

You need the count of rows?

If so you need to use Excel.sheet("SheetName").outDatatableValue.RowCount

Cheers

Cheers

[darpan.sharma]

hello, I am trying to run a condition here. In column A, if ICCID length is more than 15 then it should print valid else invalid.

For example : this is working for A2 (Excel.Sheet(“Sheet1”).Cell(“A2”) > Len(15)), but I dont want to try something that it can just check the condition for whole column A

[darpan.sharma]

able to fix it :