Email Automation with Studio - Practice 2 Send Emails, question about the DataColumn Object

Learning Hub Academy Feedback
,
1

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?

image
image1286×447 28.9 KB

2

Hi @matchett.joshua

Datacolumn.tostring.length gives the length of system.object

Please try datacolumn.count.tostring

Thanks

3

Hi @matchett.joshua

IF you need to check the Rows Counts of the datatable

…YourDt.Rows.Count—>Int32(Variable)

To Check Column Count .

YourDt.Columns.count---->Int32(Variable)

Regards
Calvin

4

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