All Questions
Tagged with winforms-interop excel
19 questions
0
votes
1
answer
2k
views
Could not load file/assembly 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. The system cannot find the file specified
I am using VS 2022 to develop windows application. In which I want to write some data into Excel. I have installed NuGet package Microsoft.Office.Interop.Excel Version 15.0.4795.1001 and I have ...
- 51
0
votes
0
answers
324
views
Converting a VBA Macro to C#
I need some help, I'm trying to convert my existing VBA macros into C# and using them with a WinForm app. I've gotten most of this macro converted, but I'm running into a wall when I try to convert ...
- 21
1
vote
0
answers
560
views
could not find xlsx file path during running of program
So, originally my program used a static spreadsheet named test, but to further enhance my program, I wanted it to make it to where the name within the textbox is the name of the file to use for the ...
- 13
-1
votes
1
answer
151
views
Slow writes to Excel cell using Excel Interop in Winforms application
I'm looking some help with my code for writing data to an Excel worksheet.
I'm currently writing data to a single cell at a time which is taking around three seconds per cell. As you can imagine, this ...
- 2,748
0
votes
1
answer
1k
views
Excel VBA to Windows Form Application Process Communication
I have been tasked to deal with an application where an excel spreadsheet needs to retrieve / access values directly from the windows form application running on a client side by side. I have been ...
- 743
4
votes
3
answers
8k
views
Error : 800700c1 in instantiating an object for Microsoft.Office.Interop.Excel.Application
I am getting the below error when instantiating the Microsoft.Office.Interop.Excel.Application() for generating Excel from the winforms app.
This was working before and suddently it stopped working ...
- 306
0
votes
0
answers
169
views
C# winForm : Excel upload not working with "Provider=Microsoft.ACE.OLEDB.12.0"
Excel uploading not working
My Application is built in Visual studio 2005
Language : C#
Type : Windows Application
It gives me below error
************** Exception Text **************
System....
2
votes
1
answer
806
views
How To Expose Running .NET Application Object To COM For VBA.GetObject? (Not Duplicate)
I am having no problems writing a .NET WinForms executable, exposing some of the classes therein to COM, and using them in Excel VBA through something like:
Set myVbaObj = VBA.CreateObject("...
- 1,876
0
votes
1
answer
131
views
Why won't the Excel process close while app is running
Question: Why won't the Excel process close while app is running? Please don't jump the gun and mark it duplicate. If you could show the change needed in the code I really appreciate it. Excel process ...
- 479
0
votes
1
answer
430
views
Cleanup and close interop excel com object when exception occurs. Winforms vb.net
How to cleanup excel com objects correctly. Hanging excel process running in task manager when exception is thrown while working with the object
If there is no error then after exiting the ...
- 479
0
votes
1
answer
3k
views
Live update data in Excel sheet from VB.NET Form
I have a form in VB.NET with .NET 4.5.
I have an EXCEL file opened side by side of the form.
I want to see the updated data from code, LIVE, in the EXCEL sheet.
But cant see the data.
Below is the ...
- 3,762
0
votes
1
answer
10k
views
Find specific data in excel sheet using vb.net
I have been trying to find a specific data in Excel through a WinForm application and then try to fetch the next value in the same row using vb.net.
Example:
ElementName Value
Age 24
Name ...
- 155
0
votes
1
answer
624
views
Proper Way cancel Background Worker in Excel process
Give the below code what would be the best way to cancel the Background Worker, so that Excel properly closes. For instance if you user closes the form in the middle of the excel process. The below ...
- 260
10
votes
3
answers
9k
views
Microsoft Office interop performance issue
I am try to exporting datagridview data to excel file in my C# 4.0 Windows application.
we used Microsoft.Office.Interop.Excel dll version 12.0.0.0. It's works well and everything
is fine. But i ...
- 3,947
4
votes
1
answer
7k
views
C# COM Interop: Writing to a Cell in an Excel Sheet
I am using Microsoft.Office.Interop.Excel in a winform where I am reading one excel file, processing the data, and outputting a new excel file. However I am having trouble writing to the cells -- ...
- 1,240