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