Read sheet (Except some sheet)

I want read sheet name except sheet Report , Summary , Note.

image

Please guide me about it.

Hi @fairymemay

use Excel application scope and create a work book variable!

Use For each and set type argument to string!

For each item in workbookvariable.Getsheets

If item.equals(“Data Jan”)

ExcelRead range sheet name = item

Regards

1 Like

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