Forum Discussion

Vicky_17's avatar
Vicky_17
New Contributor
4 years ago

How to read a range of excel cells as List or List of List Python using Excel OLE Objects?

I am migrating the existing vba code to py. so we are using the ole object to read excel like below.   can someone help to read range of cells, the documentation points to read only a single value ...
Script Tests
Vicky_17's avatar
Vicky_17
New Contributor
4 years ago

i want to read a range of cell not Single cell

  • ebarbera's avatar
    ebarbera
    Staff
    4 years ago

     Hello Vicky_17 - 

     

    I apologize I read that post incorrectly - is the script you have there not working? Or is it the vba script and you are just having trouble with the conversion process? Also - where are you looking to store the data after you read it from the excel sheet. 

     

    Thanks,

    Emma

    • Vicky_17's avatar
      Vicky_17
      New Contributor
      4 years ago

      It is taking long time to load data one by one and My PC is hanging and fan is running fast once i click run .It was a python script. i want to store the read data as List of Lists in python