I need the robot do the reading Excel and print how many lines are filled in the Excel document.
How can I do this?
I need the robot do the reading Excel and print how many lines are filled in the Excel document.
How can I do this?
Use a Read Range activity to read the data, then use DtData.Rows.Count.ToString
to get the number of rows as a string, where DtData
is the datatable you’ve saved the Excel data in. If your workbook does not have headers, uncheck the Add Headers option in the Read Range activity.
Can you send me a printscreen, please ?
I couldn’t open the file
For some reason, the forums will not allow me to upload anything. Not sure what’s going on with that.
did not work here.
When I added a value on the line it brought the wrong result
There were 5 records in the test workbook if you do not count headers. If you read the data after you’ve made your adjustments, you’ll get the correct count.
Can you share your some sample excel file ?
Thank yooou!!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.