Forum Discussion

hxiao's avatar
hxiao
Occasional Contributor
9 years ago

How to select Excel sheet in python?

Hi, From https://support.smartbear.com/viewarticle/69443/#_ga=1.128686159.2137448148.1449520310 I have python code to read Excel file:   def ReadDataFromExcel(): Excel = Sys.OleObject["Excel.App...
  • ghuff2's avatar
    ghuff2
    9 years ago

    The Sheets collection has to be accessed using Item just like the Cells collection.

     

    For example, your line of code should change to this:

     

    sheet = Excel.Workbooks.open(file).Sheets.Item["Sheet1"]

    Hope that helps.

NisHera's avatar
NisHera
Valued Contributor
9 years ago

i'm not a python guy ...

just try 

sheet = Excel.Workbooks.Open("C:\\Work\\TestBook.xls").Sheets("Sheet1")
rowCount = sheet.UsedRange.Rows.Count
  • hxiao's avatar
    hxiao
    Occasional Contributor
    9 years ago

    Hi NisHera,

     

    Thank you for your reply. Actually I have tried the same thing, but it didnot work. The error is "The specified object is not callable."

     

    I also tried :

    sheet = Excel.Workbooks.open(file).Sheets["Sheet1"],  the error is "The specified object is not indexable."  so it must be some special way in python to select sheet.