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

How are you accessing Excel via COM or Excel Object? 

You can either create your own method to perform the comparison (shown in In Script Tests) or use the Excel Checkpoints. 

Working with Excel COM gives you more flexibility, and there's plenty of examples on the Internet. It does require Excel to be installed though. Whereas, Excel Object has limited functionality and is specific to TestComplete.

Snippets of code to access work sheets,

wb = excel.Workbooks.Open(r"C:\path\file.xlsx")
sheet1 = wb.Worksheets(1) # Accessing sheet via index
sheet2 = wb.Worksheets(2)

sheet1 = wb.Worksheets("Sheet1") # Accessing sheet via name
sheet2 = wb.Worksheets("Sheet2")

Log.Message(wb.Worksheets.Count) # Number of worksheets

# Loop through all worksheets
for sheet in wb.Worksheets:
    Log.Message(sheet.Name)

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: TestComplete ExcelFile object and SheetByTitle method

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.

P.S.  We use the Sys.OleObject Property to access Excel and it work well for us.

https://support.smartbear.com/testcomplete/docs/reference/test-objects/members/sys/oleobject-property-sys-object.html?sbsearch=Sys.OleObject(%22Excel.Application%22)%3B

Let us know how it goes!  

Hello Afreen, 👋🏼

I am not much on Python but this is a JavaScipt version that will take the workbook object and Sheet Name specification and return the sheet object.

This link should explain a lot.  

https://support.smartbear.com/testcomplete/docs/reference/program-objects/excelsheet/index.html

/* JavaScript */

GetExcelFileSheetObject(objExcelWorkBook, strSheetName) {
  try {
    let objSheet = objExcelWorkBook.Sheets.Item(strSheetName);
    return objSheet;
  }
  catch(ex) {
    Log.Error("GetExcelFileSheetObject: " + ex.stack);
  }
}

AI 🤖 translates it as this...

Python Version (openpyxl):

def get_excel_file_sheet_object(workbook, sheet_name):
    try:
        sheet = workbook[sheet_name]
        return sheet
    except Exception as ex:
        print(f"GetExcelFileSheetObject: {ex}")

Usage Example:

from openpyxl import load_workbook

workbook = load_workbook("example.xlsx")
sheet = get_excel_file_sheet_object(workbook, "Sheet1")

If You Want Logging Instead of print:

import logging

def get_excel_file_sheet_object(workbook, sheet_name):
    try:
        return workbook[sheet_name]
    except Exception as ex:
        logging.error("GetExcelFileSheetObject: %s", ex)
        return None

I hope this gets you close enough to get going!

... If you find my posts helpful drop me a Like👍 Be sure to mark the post as the Solution✅ when you get one to help others out and to credit the one who helped you. 😎