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

Hi Vicky,

I’m not well versed in Python, but you should be able to declare the range like this:

     Range = Excel.ActiveSheet.Range("A2:C3") 

So, the sample code would be something like this...changes are in bold.

Excel = Sys.OleObject["Excel.Application"]
Excel.Workbooks.Open("C:\\MyFile.xlsx")

Range = Excel.ActiveSheet.Range("A2:C3"); 

      ##whatever range you need…I used A2 to C3

for i in range(1, Range.Rows.Count + 1):
    s = "";
    for j in range(1, Range.Columns.Count + 1):
        s = s + VarToString(Excel.Cells.Item[i, j]) + '\r\n' 
    Log.Message("Row: " + VarToString(i), s);

Excel.Quit();