tsiank

Excel Interop, Could not load file or assembly

7

**Describe the bug** I use Microsoft.Office.Interop.Excel.dll in RoslynPad15 DotNet 6.0 to read and write Excel, but it shows error: "Could not load file or assembly 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. "...

Now if I query worksheet1 and worksheet2, my code is like: var sheet1Result = MiniExcel.Query(worksheet1); var sheet2Result = MiniExcel.Query(worksheet2); var joinResult = from sheet1 in sheet1Result join sheet2 in sheet2Result...

"win32com.client.gencache.EnsureDispatch" doesn't work on office 64bit

3

I'm using python 3.8 64 bit on windows 10 64bit , my excel is office365 64bit and office 2016 64bit, pywin32 is 228. when I use win32com.client.gencache.EnsureDispatch('Excel.Application') , it raises...