When trying to execute the below code
import time
app=xw.App(visible=False)
wb=app.books.open( r"c:\test\x.xlsm")
ws=wb.sheets['Sheet1']
wb.save()
wb.close()
app.kill()
In visual studio (version 17.3.3 (2022) ) ,I'm getting the below error.
Stack trace:
> File "C:\Users\user1\AppData\Local\Temp\gen_py\3.10\00020813-0000-0000-C000-000000000046x0x1x9.py", line 41316, in __call__ (Current frame)
> ret = self._oleobj_.InvokeTypes(0, LCID, 2, (13, 0), ((12, 1),),Index
Can anyone please let me know how to resolve this.
I have tried reinstalling all the python modules ,but nothing seems to be working . I tried to uncheck the uncaught and raised exception breakpoint, But I'm unable to find those check box in this VS version.It is not present in Debug tab as well.