Forum Discussion

SanM's avatar
SanM
Occasional Contributor
9 years ago

How to get the Excel sheet names using OLE object python testcomplete

I am new to the TC and code   gExcel = Sys.OleObject["Excel.Application"] except: Log.Warning("Unable to intialize the excel file.") return Wrkbk = gExcel.Workbooks.Open(Excel_path) gExcel.V...
Ravik's avatar
Ravik
Super Contributor
9 years ago

I am using - "openpyxl" module, we can get the sheet name (but you have to install - openpyxl)

 

import openpyxl

 

def getExcelSheetName():

    wbo = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx")

    wso = wbo.get_sheet_names()

    for shname in wso:

        Log.Message(shname)