I am trying to convert a tuple into a list using the “list” function. Before I do this I have this:

 

print CurSht.Range("A2:A63")

((45666.0,), (45777.0,), (45888.0,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,), (None,))

 

Then I get this:

 

print list(CurSht.Range("A2:A63"))

[<win32com.gen_py.Microsoft Excel 11.0 Object Library.Range instance at 0x16031176>, <win32com.gen_py.Microsoft Excel 11.0 Object Library.Range instance at 0x16031216>, <win32com.gen_py.Microsoft Excel 11.0 Object Library.Range instance at 0x16031256>]

 

(It has many more instances than this. I shortened it in order to make this less lengthy)

 

Not sure why the values turn into these instances that don’t have the attributes I need. Any help for this noob would be much appreciated.

 

Thanks,

 

Clayton

-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to