I'm writing a python plugin for a geo referencing program called QGIS where I want an Excel sheet to do all my calculations for me. For different data points I need to set certain input values into the spreadsheet (which was already written by someone else).
I'm fine setting the int values (using win32com.client) with
Expand|Select|Wrap|Line Numbers
- sheet.Cells(row, col).Value = value
Expand|Select|Wrap|Line Numbers
- sheet.opt_name.Value = True
AttributeError: '<win32com.gen_py.Microsoft Excel 12.0 Object Library._Worksheet instance at 0x232878608>' object has no attribute 'opt_name'
What are the options attributes of? How do I set their values?
Thanks a lot for any help!