Can we set sheet name in excel as active using python script

If you’re using TestComplete’s built-in Python and can’t install additional libraries, you can work with Excel through TestComplete’s Excel object model rather than external packages. TestComplete provides the TestComplete ExcelFile object which allows you to access sheets directly by name or index.

For example, you can iterate through the sheets like this:

excelFile = Excel.Open("C:\\temp\\DataStorageExcel.xlsx")

for i in range(1, excelFile.SheetCount + 1):
    sheet = excelFile.SheetByIndex(i)
    Log.Message(sheet.Title)

If you already know the sheet name, you can reference it directly:

sheet = excelFile.SheetByTitle("Sheet1")

This approach is documented in the TestComplete documentation for the ExcelFile object and sheet access methods: https://support.smartbear.com/testcomplete/docs/reference/program-objects/excelfile/index.html object and https://support.smartbear.com/testcomplete/docs/reference/program-objects/excelfile/sheetbytitle.htmlmethod

In most cases you don’t need to “activate” sheets for comparison tasks. Instead, you can reference them directly using SheetByTitle or SheetByIndex and read the data from the returned sheet object.

If this resolves your scenario, marking it as the solution helps future readers find it quickly.