Forum Discussion

Ravik's avatar
Ravik
Super Contributor
8 years ago

How to get Excel sheet name in TestComplete:Python

I am looking for a way to read all of the sheet names from an Excel workbook. Since the ExcelDriver requires a sheet name I am not sure how to do this.  I am using Python script.  Any ideas?   My C...
Ravik's avatar
Ravik
Super Contributor

NisHera Thanks for help,

 

Is there any Python code for same or do we need to import any external python libraries like - import openpyxl

to perform action.

 

 

NisHera's avatar
NisHera
Valued Contributor
8 years ago

 I don't thing you need external libraries

pl check your sample code usually at C:\Users\Public\Documents\TestComplete 12 Samples\Common\MSOffice\Python\Excel_Python

  • Ravik's avatar
    Ravik
    Super Contributor
    8 years ago

    NisHera,

     

    I am using TestComplete 11.3, there is no sample for Python :(

     

    Well I have import openpyxl  library and used openpyxl libraries functions.

     

    wbo.get_sheet_names()

     

    or

    workbookobj.get_sheet_by_name("sheet1")