How to show a message with the total of lines and with a specific column that was extracted

Hello guys.

My doubt is how I can make my robot show a message with the total of lines from a excel table, and after this show a message with the total of lines too from a specific column.

Hi @Gabriel_Mascarenhas

First read the excel and Store it in datatable,

Variable name dtTable

For total row count dtTable.rows.count

For particular column row count,
dtTable.defaultview.totable(false,“columnname”).rows.count

Got it, but how I can build this ? My robot already go to an website, extract datas and creat a excel spreadsheet with all the informations extracted from browser.

!

@Gabriel_Mascarenhas

Welcome to forums

After the Read Range activity you can place the log message activity and write as prasath said

Place a log message and write as dtTable.rows.count to get the total rows count

For particular column row count,
dtTable.defaultview.totable(false,“columnname”).rows.count

The output will show in UiPath output

Hope this may help you

Thanks

Basically the program is working until the Append Range, I don’t know how to continue this…

I’ve tried to do what both of you said, but it still not work probably because I’m forgetting to put something :frowning:

Why are you using append range,try use write range activity and check if the excel is created… thanks

I tried use write range and it worked, but what is the next step ?

Put 2 log message activity

In first log message give
dtTable.rows.count - it will give total row count

In second log message
dtTable.defaultview.totable(false,“columnname”).rows.count -
For particular column row count

Thanks for taking a time to help me, now everything is working. :slight_smile:

Happy to hear…please mark it as solution if your issue is resolved… thanks

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