15 questions
0
votes
1
answer
86
views
VB NET Microsoft.Office.Interop open XML file as XML table
I have a piece of code where I am opening an XML file from VB NET console app, than I Save As this file as XLSX file
Dim oxl As Excel.Application
Dim owbs As Excel.Workbooks
Dim owb As Excel.Workbook
...
0
votes
0
answers
1k
views
Upgraded .Net 4.8 to .Net8.0 (Core), Microsoft.Office.Interop no longer recognises certain key words
I've upgraded a legacy C# WPF app from .Net 4.8 to .Net8.0 (Core).
Removed the NuGet packages for Microsoft.Office.Interop both word and excel and replaced with COM references (8.7 and 1.9 ...
- 65
0
votes
1
answer
148
views
Microsoft.Office.Interop.Excel not working after migrating to PackageReference
yesterday I restructured my files and projects a bit and since I did this I have this new errormessage " Must use PackageReference".
I quickly found out that I have to migrate the packages....
- 11
0
votes
1
answer
487
views
How to solve error 0x80029C4A while exporting data from C# to Excel?
I'm using Visual Studio 2022 Community. On my pc there is Microsoft Office 2013. I installed "Microsoft.Office.Interop.Excel" version 15.0.0.0; Runtime version v2.0.50727.
I'm trying to ...
- 1
2
votes
3
answers
737
views
Writing to Excel in F#
Has anyone got experience of writing values to an Excel spreadsheet from F# using Microsoft.Office.Interop? I can read values fine, but when I try to change the value of a cell I always get an error. ...
- 53
0
votes
1
answer
140
views
C# - Need to Merge two excel sheet into one Excel Sheet
for proccessing excel need to append shee2 into shet1 after sheet1 data with cell style and not using any nuget
var App = new Microsoft.Office.Interop.Excel.Application();
Workbook book1 = App....
0
votes
2
answers
75
views
Need to merge the worksheets of some workbooks into one new workbook using C#
My project is about getting four worksheets from different workbooks (Excel files) and add them into a completely new workbook. I'm using this logic to get Excel sheet into worksheet object and add ...
1
vote
0
answers
760
views
System.IO.FileNotFoundException: 'Could not load file or assembly 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken
I have a console app and trying to read Excel file, by using the library: Microsoft.Office.Interop.Excel
I get below error:
System.IO.FileNotFoundException: 'Could not load file or assembly 'office, ...
- 9,124