[python-win32] ActiveSheets and excel
by Graeme Glass other posts by this author
Sep 28 2004 2:52PM messages near this date
[python-win32] win32com, excel and wx
|
Re: [python-win32] ActiveSheets and excel
When dispatching your own instance of excel, it is pretty straight
forward to access the workbook and ActiveSheets by way of the
Excel.Application object, in this case exapp.
eg:
exapp = win32com.client.Dispatch("Excel.Application")
exapp.Visible = 1
exapp.Workbooks.Add()
exapp.ActiveSheet.Cells(1,1).Value = 'hello'
my question is, how does one add, remove workbooks, and access
ActiveSheets from with excel by means of an Addin? I have been
attempting to access it throught what i thought was the application
interface in the plugin but it is not :-)
So i currently stand with a plugin button that can bring up message
boxes and frames but not do anything really usefull. Any help would be
very much appreciated.
Thanks, Graeme
_______________________________________________
Python-win32 mailing list
Python-win32@[...].org
http://mail.python.org/mailman/listinfo/python-win32
Thread:
Graeme Glass
Fabricio Guzman
|