Apache OpenOffice Community Forum

Posted: **Sat Sep 14, 2013 4:13 am**

I am using Python.

doc = XSCRIPTCONTEXT.getDocument()
oSheets = doc.getSheets()
sSheet = doc.getCurrentController().getActiveSheet()
name = sSheet.Name

Will get me the name of the active sheet. How do I get it's index?

Thanks, Jim

Posted: **Sat Sep 14, 2013 5:31 am**

sSheet.RangeAddress.Sheet

Posted: **Sat Sep 14, 2013 4:41 pm**

Thank you, that worked. Knew it was something simple, just couldn't come up with it.

Regares, JIm

[Solved] How to get the active sheets index?