Geek asks and answers

Error in Excel

I am having an urgent problem with the following error setting the DisplayAlerts property for Excel ApplicationClass to false.

var excel = new Excel.Application();
excel.DisplayAlerts = false;

The following error message appears in the logs:

System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
     at Microsoft.Office.Interop.Excel.ApplicationClass.set_DisplayAlerts(Boolean RHS)
     at Service.Dispose()

The following MessageBox is displayed.

http://www.xlam.ch/xlimits/Nicht-genug-Speicher-fuer-vollstaendige-Anzeige.gif

Any ideas on this occasion?

MacX Relations

+3
source share
2 answers

I think you should call DisplayAlertsin the instance you are Excel.Applicationworking with. Something like that:

var excel = new Excel.Application();
excel.DisplayAlerts = false;
0
source

You will have to catch this error and resubmit everything that you insert into the cell on excel. This is an annoying mistake, and I could not implement an elegant solution for.

- , , , Excel "" , , . , , . , .

, , - , .

0

More articles:


All Articles