Any way to reference Reporting.Explorations without a specific sheet name

[ahavas]

Hello,

I can programatically interact with Quick Reports using an ID number rather than a specific cell, e.g. Reporting.QuickReports.Get(<qridnumber>).Commit which is very useful when iterating over an array of the qr id numbers.

Is there an equivalent for Explorations? The documentation seems pretty insistent that the correct form is: Reporting.Exploration.GetAt(<excelsheetname>).SomeFunction. I ask because I see there is a Reporting.Explorations.GetReports() accessor, but its use case is not at all clear. What I am trying to do is programatically refresh certain Explorations but not others, without needing to know the sheet name.

Thanks!

[tedphillips]

because Exploration Reports is a one-per-worksheet technology, the 'id' equivalent is the worksheet (within the scope of the book).

how would you be looking to selectively consume the explorations, as in, what matching criteria do you envision?

GetReports() produces a collection of all Explorations in the book, which you can then iterate in a loop in a similar way.

[ahavas]

Understood and it makes sense.

Would you be able to provide a sample on how to use GetReports()?