How to get the name of the active sheet in excel. I have an excel file with many sheet names but depending upon the situation only one name will come when we open the excel file. Is there any way we can get the active /current excel sheet name.?
FYI: i cannot use workbook.getsheet and loop it and get each name. What ever sheet name comes first while opening it must be displayed.
I tried using workbook.currentsheet.name but gets error " Object reference not set to an instance of an object."
While using workbook.getworkbooksheet(index) im getting the sheet name but is there any way we can get name name instead of this method?
Thanks in advance