title: Collapse columns in Excel with Python
body: <p>I am making a script to parse results from a database into Excel. I have both my rows and columns grouped. I have a method for folding the group (with the +/- button). I can collapse my rows via:</p>
  
  <pre><code>call: e.showLevels(1,0)
  def showLevels(self, rowlevel, collevel):
      self.e.ActiveSheet.Outline.ShowLevels(rowlevel,collevel)
  </code></pre>
  
  <p>This works for collapsing rows. When i try e.showLevels(0,1) f.e. it doesn't work. Also when i only do this at the end of the grouping:</p>
  
  <pre><code>e.e.ActiveSheet.Outline.ShowLevels(1,0) //works for rows
  e.e.ActiveSheet.Outline.ShowLevels(1,1) //works ONLY for rows. Not columns.
  e.e.ActiveSheet.Outline.ShowLevels(0,1) //rows = 0 so not showing. Still columns not working
  </code></pre>
  
  <p>Simple said i can fold rows but i can't fold columns. Anybody has an idea how to make this work for the columns?</p>
  
  <p><strong>EDIT: e.e. and self.e reference to the Excel workbook. ActiveSheet references to the current sheet.</strong></p>
  
  <p>Thanks in advance!!</p>