How to delete columns in xlwings?
<p>I'm using <code>xlwings</code> on Windows (Excel 2007 with Python 2.7) and would like to delete either ranges or columns with <code>xlwings</code>. As far as I could see, deletion of a range or a column is a missing feature, so I tried to follow the instructions given <a href="http://docs.xlwings.org/en/stable/missing_features.html" rel="nofollow">here</a> and tried to access the <code>.Delete</code> method of Range object in VBA. Do you have any suggestions on what is causing the error and how to delete a range of whole column in <code>xlwings</code>?</p>

<p>The code I was trying to run in command line is below (for deleting the whole column in the active workbook):</p>

<pre><code>import xlwings as xw
wb = xw.Workbook.active()
xw.Range('C1:C3').xl_range.EntireColumn.Delete
</code></pre>

<p>I received the following error:</p>

<pre><code>bound method CDispatch.Delete of &lt;COMObject &lt;unknown&gt;&gt;&gt;
</code></pre>

<p><code>Xlwings</code> would offer the possibility to clear values from range (by <code>Range('C1:C3').clear()</code>), but that would leave an empty range or column to the sheet.</p>