Top "Xlwings" questions

Xlwings is a module to allow Excel to be automated with Python instead of VBA.

Read data in Excel column into Python list

I am using python xlwings to read a column of data in Excel 2013. Column A is populated with numbers. To …

python excel xlwings
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2147352565), None)

I was created example from http://docs.xlwings.org/en/stable/vba.html /Python 3.5.1 |Anaconda 2.5.0 (32-bit)| (default, Jan 29 2016, 15:46:01)/ and got …

xlwings
How do I call an Excel macro from Python using xlwings?

I've read the API docs for xlwings, and played around with Workbook and Sheet objects in the interpreter, but I …

python excel vba xlwings
xlwings function to find the last row with data

I am trying to find the last row in a column with data. to replace the vba function: LastRow = sht.…

python python-2.7 xlwings
Open a Workbook with XLWINGS without making it visible

I am starting to use XLWings (not that I like Excel, at all, but it is something I HAVE TO …

python excel visibility xlwings
python xlwings - copy and paste ranges

My first question on this site. I am using xlwings with python 2.7. I want to copy the values in range …

python excel xlwings
xlwings: Save and Close

I am trying to find out how to save and close to an existing workbook using xlwings after writing in …

python excel xlwings
A whole sheet into a panda dataframe with xlwings

Thanks to panda, we could read a whole sheet into a data frame with the "read_excel" function. I would …

python excel pandas xlwings
How do I save a workbook using xlwings?

I have an excel worksheet, some buttons and some macros. I use xlwings to make it work. Is there a …

python excel vba xlwings
Any way to create a new worksheet using xlwings?

Using Python xlwings, how can I create a new worksheet?

python excel xlwings