I’m going through the second practice problem of Email Automation with Studio (UiPath Academy), and was looking through the solution provided with it. I do not understand what is happening with the formula to pull the range to write the ID formula. The solution provided is giving a different row count than I would expect. The Excel file provided has 11 rows, but the formula used DataColumn.ToString.Length.ToString gives 15? But DataColumn itself is only claiming 11 when I look at the results in the immediate pane while debugging? Why is the formula adding 4 extra rows?
Datacolumn.tostring.length gives the length of system.object
Please try datacolumn.count.tostring
IF you need to check the Rows Counts of the datatable
To Check Column Count .
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.