Read Excel Data

Help StudioX
1

I have attached my Excel file and I wish to save the highlighted information from page 2 in a datatable.
export.xlsx (9.5 KB)

2

@parnalmahavir.patni,

Please share the approach you tried and issue you are facing if any.

3

The image is a screenshot of an automation workflow, showing a "For Each Row in Data Table" loop with an "If" condition checking if a string value is greater than "10", and updating counters and logging messages within the "Then" section. (Captioned by AI)
The image is a screenshot of an automation workflow, showing a "For Each Row in Data Table" loop with an "If" condition checking if a string value is greater than "10", and updating counters and logging messages within the "Then" section. (Captioned by AI)720×769 64.6 KB

Reading excel in datatable and using for each until i reach 11th cell. but the if condition doesnt work

4

@parnalmahavir.patni what issue you are facing?
Read excel–>store in datatable–>use datatable as per the requirement

5

@parnalmahavir.patni,

You can’t really check string is greater than another string.

Try this condition instead

CInt(str_cellno.ToString) > 10
2 Likes
7

Hi @parnalmahavir.patni

Check with read range Activity, Just specify the range

image
image578×589 14.8 KB

Hope this helps!

8

The range is dynamic. So i cant use the cell numbers

9

@ashokkarale I cant access the last value of the row from the excel.
The for each row terminates one row before the last one.
My data table from excel read range has all the rows in it.

This image depicts a visual sequence of activities in UiPath Studio for iterating through rows of a data table, assigning values, conditionally incrementing a counter, and logging messages. (Captioned by AI)
This image depicts a visual sequence of activities in UiPath Studio for iterating through rows of a data table, assigning values, conditionally incrementing a counter, and logging messages. (Captioned by AI)736×777 63.5 KB

The image depicts a sequence of activities in a workflow automation script, including reading a cell value from an Excel sheet, logging the output message, and a commented-out section for invoking an SAP workflow. (Captioned by AI)
The image depicts a sequence of activities in a workflow automation script, including reading a cell value from an Excel sheet, logging the output message, and a commented-out section for invoking an SAP workflow. (Captioned by AI)700×641 51.1 KB

10

@parnalmahavir.patni,

Check if your dt_ReportRaw have that last row.
Remember row numbers starts from zero. So your first row would be 0th row and your last row would be total rows -1

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.