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.
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.
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.
!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
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.
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.