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

Hey so the error means:

>>> import win32api
>>> win32api.FormatMessage(-2147352565)
'Invalid index.\r\n'

So my guess is that you're trying to write to an inexistent sheet (and yes, we shall be working on easier-to-understand error messages...)

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.

Related