title: Documentation for Excel python COM object?
body: <p>I want to use Python and COM to manipulate data and formula in Excel files. I've looked around a couple of modules in python but I have yet to find support for reading formulas. So I am forced to use COM. I'm not sure what to call it but is there something like a documentation for all the classes and methods available on python,COM for excel. There are a few sample codes here and there but I can't seem to find any exhaustive documentation for what I want to do.</p>
  
  <pre class="lang-python prettyprint-override"><code>import win32com
  import win32com.client
  xl = win32com.client.Dispatch("Excel.application")
  xl.__doc__
  </code></pre>
  
  <p>I thought the last line would print a list of methods or documentation for the Excel application</p>
  
  <pre><code>sel = xl.Selection
  </code></pre>
  
  <p>Selection() method above does not display when I hit TAB after xl. I just know there is a Selection method because I read it from a pyxll sample module. So I assume there's more methods out there that's not included in the TAB menu.</p>
  
  <pre><code>sel.Value = "Hello!"
  sel.font.bold = true
  
  Traceback (most recent call last):
  File "&lt;pyshell#8&gt;", line 1, in &lt;module&gt;
  sel.font.bold = true
  NameError: name 'true' is not defined
  
  sel.font.bold = 1
  sel.font = "Constantia"
  
  Traceback (most recent call last):
  File "&lt;pyshell#10&gt;", line 1, in &lt;module&gt;
  sel.font = "Constantia"
  File "C:\Python27\lib\site-packages\win32com\client\dynamic.py", line 570, in  __setattr__
  raise AttributeError("Property '%s.%s' can not be set." % (self._username_, attr))
  AttributeError: Property '&lt;unknown&gt;.font' can not be set.
  </code></pre>
  
  <p>So I'm guessing around with this but I want to learn with a proper documentation so I know what objects/methods are available to me. Can anyone point me to the right direction? Thanks in advance!</p>