Re How to get the Excel sheet names using OLE object python testcomplete I am using openpyxl module, we can get the sheet name (but you have to install openpyxl) import openpyxl def getExcelSheetName () wbo = openpyxlload_workbook (C\TC_Python\Test1xlsx) wso = wboget_sheet_names () for shname in wso LogMessage (shname)Import excel file in python pandas;Contents Introduction Getting Started with XlsxWriter Installing XlsxWriter Running a sample program Documentation Tutorial 1 Create a simple XLSX file Tutorial 2 Adding formatting to the XLSX File Tutorial 3 Writing different types of data to the XLSX File
How To Get All Sheet Names From All Workbooks In A Folder How To Excel