Category "xlwings"

pywintypes.com_error: (-2147352567,'Exception occured.', (0, None, None, None, 0, -2147352566)

Background： I am using xlwings to open an xlsx file and use a list (tuple) to receive all the data of the table. The code is as follows. def get_excel_al

Get location of the workbook calling the script

I am trying to execute the following Python script from Excel using Sub MacrosTrigger() RunPython ("import MacrosTrigger") End Sub MacrosTrigger.py conta

Print Excel to pdf with xlwings

I am trying to print Excel files to pdf with xlwings. I am using the excel api for this. I have tried it in two ways: 1/ Using the PrintOut() call with PrintT

How to use Xlwings RunPython for file name with spaces

I am trying to run a python function called comments() from vba and getting an error with the following code due to spaces in the file name: Sub notes() Dim f

Is there a way to calculate a particular sheet in excel using python?

I need to calculate a sheet of interest in excel using python. There is a method to calculate the entire workbook using the following code. import xlwings as xw

Why do I get an enumeration error using xlwings?

I'm using xlwings and when I try to open the excel workbook I get a strange error. It seems to come from the xlwings source code so I don't know what to do. Doe

Move worksheet within a workbook to the end [duplicate]

With xlwings, I am trying to move a worksheet within a workbook to the end. For example, a workbook contains a collection of the following she