Get Sheet Count in Workbook


#1

Hello People,

Can somebody guide me to get the count of number of sheets in a Workbook, not Excel. Thanks in advance.

@arivu96

Regards,
Nithin


#2

Hi @nithin2304,

use excel application scope activity

Readsheetname.xaml (7.7 KB)

Regards,
Arivu


#3

@arivu96 .
Thanks for your instant reply.
It shows error as “Activity could not be loaded as there are errors in xaml.” Can you please attach screenshot.

And, we don’t use Excel in our Company, rather we use Libre office. So Excel Application wont work it seems. Is it possible to work with Workbook?

Regards,
Nithin