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

[matchett.joshua]

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?

[prasath_S]

Hi @matchett.joshua

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

Please try datacolumn.count.tostring

Thanks

[pravin_calvin (pravin kumar)]

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