insufficient memory to create an excel workbook

Question

My original code:

    Excel.Application xlErrorApp;
    Excel.Workbook xlErrorWorkBook;
    Excel.Worksheet xlErrorWorkSheet;
    object misValue = System.Reflection.Missing.Value;
    xlErrorApp = new Excel.Application();
    xlErrorWorkBook = xlErrorApp.Workbooks.Add(); // -> error
    xlErrorWorkSheet = (Excel.Worksheet)xlErrorWorkBook.Worksheets.get_Item(1);

A get error in line 6.

Error Message:

Application Microsoft Excel can not open or save documents due to insufficient memory or disk space.

I just tested your code and it runs fine (it needs tidied up though), what version of C# are you using, and could it be that you actually are low on RAM/disk space? — JMK
– JMK, Commented Jan 9, 2013 at 10:17

GeorgesD · Accepted Answer · 2013-01-09 10:03:27Z

2

Which library are you using ?

I already said it but actually Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

I recommend you to look for a free library like Open Office XML or a not free library like Aspose.

answered Jan 9, 2013 at 10:03

GeorgesD

1,0825 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1848942 Over a year ago

It's impossible because users use only excel files on local machines.

Soner Gönül · Accepted Answer · 2013-01-09 10:10:19Z

1

Workbooks.Add() method from MSDN;

Parameters
Template
Type: System.Object

Optional Object. Determines how the new workbook is created. If this argument is a string specifying the name of an existing Microsoft Excel file, the new workbook is created with the specified file as a template. If this argument is a constant, the new workbook contains a single sheet of the specified type. Can be one of the following XlWBATemplate constants: xlWBATChart, xlWBATExcel4IntlMacroSheet, xlWBATExcel4MacroSheet, or xlWBATWorksheet. If this argument is omitted, Microsoft Excel creates a new workbook with a number of blank sheets (the number of sheets is set by the SheetsInNewWorkbook property).

If you try to create new workbook, try like this;

Workbook newWorkbook = this.Application.Workbooks.Add(missing);

answered Jan 9, 2013 at 10:10

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

1 Comment

user1848942 Over a year ago

Yes. At first i did like you wrote. It's not important in that case.

tomfanning · Accepted Answer · 2013-01-09 10:11:01Z

1

how about this:

Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Open(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing);

edited Jan 9, 2013 at 10:11

tomfanning

9,6604 gold badges53 silver badges79 bronze badges

answered Jan 9, 2013 at 10:10

Adam Bilinski

1,1981 gold badge18 silver badges28 bronze badges

Comments

user1848942 · Accepted Answer · 2013-01-09 11:34:08Z

1

I'm sorry I could not find the link earlier. I used EPPlus supports. http://epplus.codeplex.com

Thanks for trying to help!

answered Jan 9, 2013 at 11:34

user1848942

3551 gold badge5 silver badges21 bronze badges

Collectives™ on Stack Overflow

insufficient memory to create an excel workbook

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related