I use Uipath and I want to check number page of excel sheet, if it larger 5 will output error. But not have activities can check it. Does somebody have the idea for it?
Asked
Active
Viewed 858 times
-1
-
I'm voting to close this question as off-topic because concept has nothing to do with the problem. – Joshua Jul 24 '18 at 03:14
1 Answers
0
If you are looking to count the number of sheets in an excel sheet,here is the method using UiPath.
Read the excel using Excel application scope store the output of the excel application scope with a variable (ex:wb) convert the variable to an array (newvariable=wb.Getsheets().ToArray) Get the length of the array (newvariable.length) This would give you the number of sheets in the excel workbook.
Regards, Swapnil
Swapnil Kadam
- 61
- 3