xlwings error when reading a workbook

[Mishal0488]

Hi Guys

I have some code which reads reads an excel file and there after uses the data to develop stress plots of structural sections.
I literally just demonstrated the program to my peers and it worked and a few minutes later is has broke down.

From what I see the issue stems from xlwings.
I have pasted a a similar set of code which produces the same error, please refer below.
Note that I am using python3.7.9

Any assistance would be greatly appreciated.


pywintypes.com_error: (-2146827284, 'OLE error 0x800a03ec', None, None)

import xlwings as wx

wb = wx.Book(r"C:\Users\mishal.mohanlal\OneDrive - Aurecon Group\GitHub resources\Plane-stress-analysis-of-sections\Book.xlsx")
sht = wb.sheets['Sheet1']

[deanhystad]

Use pandas. Xlwings is the wrong kind of tool for just reading an excell file.