Menu
I'm using xlwings on Windows (Excel 2007 with Python 2.7) and would like to delete either ranges or columns with xlwings. 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 here and tried to access the .Delete 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 xlwings?
The code I was trying to run in command line is below (for deleting the whole column in the active workbook):
import xlwings as xw
wb = xw.Workbook.active()
xw.Range('C1:C3').xl_range.EntireColumn.Delete
I received the following error:
bound method CDispatch.Delete of <COMObject <unknown>>>
Xlwings would offer the possibility to clear values from range (by Range('C1:C3').clear()), but that would leave an empty range or column to the sheet.
444
Python Delete Excel Rows and Columns In openpyxl, we can use delete_rows() and delete_cols() methods from the Worksheet object to remove entire rows and columns. The syntax is straightforward: delete_rows(row_id, number_of_rows) delete_cols(col_id, number_of_cols)
Xlwings Excel Add-In But thanks to Xlwings we can now add a VBA macro into Excel, so we can start the Jupyter Notebook out of Excel. The basic concept is simply to write your Jupyter Notebook code into a main function, export that as a Python file (. py) and call that Python script out of Excel's VBA Editor.
Since v0. 26.0, xlwings can be installed on Linux servers in connection with Google Sheets or Excel on the web, see Remote Interpreter. xlwings requires at least Python 3.7.
Xlwings can be used to insert data in an Excel file similarly that it reads from an Excel file. Data can be provided as a list or a single input to a certain cell or a selection of cells.
Access the entire column and then use .xl_range.Delete() instead:
xw.Range('C:C').xl_range.Delete()
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
