Unable to write data runtime in Excel app using c# asp.net

Question

5.00/5 (1 vote)

See more:

I am getting error:
System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. • To make more memory available, close workbooks or programs you no longer need. • To free disk space, delete files you no longer need from the disk you are saving to.

This error I get while I deployed my APP in server 2008 in production envirnment.

Locally it's working fine.

I am using Excel 2007 to write data. and same I have installed in server also.

My functional requirement is we need to write data in Excel runtime and to send as an attachment in mail.

I have already given all permission using COMPOnent Service and I tried changeing Identity to administrator to run app. Then also getting same issue.

Anybody can help me on this as this solution is bit urgent.

Thanks in advance.

Posted 10-Jun-10 20:51pm

Vishal Sanchihar 1981

Add a Solution

4 solutions

Solution 1

If you have disc space available, then it has to be a permissions issue, surely ? Even if you think it can't be, what else can it be ?

Posted 11-Jun-10 1:51am

Christian Graus

Solution 2

I think this is happening when too many instances of excel has been opened. Your com object was not released properly after use. Check your Task manager while the error is comming and look for Excel.exe in application tab. If you find so many instances of Excel.Exe then you need to release the COM object explicitly after use and re-create another excel application.

Posted 11-Jun-10 21:47pm

Goutam Patra

Comments

Vishal Sanchihar 1981 14-Jun-10 1:44am

There is no Excel.exe in task process. and also there are enough space in DISK..

For more detail.... here is my code example:

Microsoft.Office.Interop.Excel.Application ExcelApp;
Workbook ExcelWorkbook;

ExcelApp = new Microsoft.Office.Interop.Excel.Application();
ExcelWorkbook = ExcelApp.Workbooks.Add(); // Error is comming in this line...

awaiting for helpful solution....

Goutam Patra 14-Jun-10 4:46am

Check in you server machines Task manager. There must be a Excel.Exe in your application tab.

Alernatively try

Dim ExcelApp As Object
ExcelApp = createobject("Excel.Application")
ExcelWorkbook = ExcelApp.Workbooks.Add();

and let me know

Solution 3

No there is no Excel.exe in Task manager...
any way no I have changed my way of writing Excel...
Now I am using Open XML...
Ex...
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

File.Copy("C:\vis.xlsx", "C:\Attachment\vis.xlsx", true);
using (SpreadsheetDocument myWorkbook = SpreadsheetDocument.Open("C:\Attachment\vis.xlsx", true))
{
// Access the main Workbook part, which contains all references.
WorkbookPart workbookPart = myWorkbook.WorkbookPart;

// Get the first worksheet.
WorksheetPart worksheetPart = workbookPart.WorksheetParts.ElementAt(2);
// The SheetData object will contain all the data.
SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();

int index = 1;
// Cell related variable
string Nom = "content to write";

// New Row
Row row = new Row();
row.RowIndex = (UInt32)index;
// New Cell

Cell cell = new Cell();
cell.DataType = CellValues.InlineString;
// Column A1, 2, 3 ... and so on
cell.CellReference = "A1";
// Create Text object
Text t = new Text();
t.Text = Nom;
// Append Text to InlineString object
InlineString inlineString = new InlineString();
inlineString.AppendChild(t);
// Append InlineString to Cell
cell.AppendChild(inlineString);

// Append Cell to Row
row.AppendChild(cell);

sheetData.AppendChild(row);
// Append Row to SheetData

worksheetPart.Worksheet.Save();

myWorkbook.Close();

}

------

and Finally there is no issue...

Posted 30-Jun-10 0:10am

Vishal Sanchihar 1981

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prosanta Kundu online · Accepted Answer · 2010-06-30T00:23:00

Fixing permissions (Windows server 2008)

A.Windows 2008 Server x64

Please make this folder:

C:\Windows\SysWOW64\config\systemprofile\Desktop

And give write permissions to the "IIS AppPool\DefaultAppPool" user in those folders:

C:\Windows\SysWOW64\config\systemprofile\Desktop
C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\Microsoft
C:\Windows\SysWOW64\config\systemprofile\AppData\Local\Microsoft

B.Windows 2008 Server x86

Please make this folder:

C:\Windows\System32\config\systemprofile\Desktop

And give write permissions to the "IIS AppPool\DefaultAppPool" user in those folders:

C:\Windows\System32\config\systemprofile\Desktop
C:\Windows\System32\config\systemprofile\AppData\Roaming\Microsoft
C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft