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

user_6077857 0
Viewed 41483

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 error 

--
---------------------------
Error
---------------------------
Traceback (most recent call last):

  File "<string>", line 1, in <module>

  File "C:\Python3\mymodule.py", line 7, in rand_numbers

    n = int(Range('Sheet1', 'B1').value)  # Write desired dimensions into Cell B1

  File "C:\Python3\lib\site-packages\xlwings\main.py", line 701, in __init__

    self.xl_sheet = xlplatform.get_worksheet(self.xl_workbook, sheet_name_or_index)

  File "C:\Python3\lib\site-packages\xlwings\_xlwindows.py", line 240, in get_worksheet

    return xl_workbook.Sheets(sheet)

  File "C:\Python3\lib\site-packages\win32com\client\dynamic.py", line 192, in __call__

    return self._get_good_object_(self._oleobj_.Invoke(*allArgs),self._olerepr_.defaultDispatchName,None)

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



Press Ctrl+C to copy this message to the clipboard.
---------------------------
OK   
---------------------------
xlwings
4 Answers

I've found that you can't use relative paths, and this is the error you get if you do use a relative path.

pass the relative path with os.path.abspath(rel_path) to open the file.

user_93551810

If the above solutions did not work then my best guess is that the excel file you using is not in focus, I had the same issue while working with xlwing. All you need to do is once select the Excel (kind of set focus event of excel) file and then run the python code.

user_59284360

in my case I was trying to refresh an Excel file but one of the required add-ins was disabled.

user_170011450
Related