To create an Excel Sheet using ASP.NET 2.0 with C#

[=?Utf-8?B?Sm9zaW4gSm9obg==?=]

I could create MS Excel sheet using ASP.NET 2.0 with C# but it is not being
created
in some systems, following error occurs when the program compiles :
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.

Line of error it shows is at: workbook = workbooks.Add(Type.Missing);

OS I tried : Windows 2003 Server,Windows XP (Service Pack 2)

COM I added : MS-Excel 5.0, MS-Excel 10.0

dcomcnfg Setting : MS-Excel->Properties->Security->Customize->Edit->Add->
ASPNET->Put tick mark on Local Launch and Local
Activation

[Munna]

Hi,

Seems to be that this is problem of the client machines... your client
machines are getting out of memory...

http://www.beansoftware.com/asp.net-...l-reports.aspx

Best of luck

-------
Munna

www.munna.shatkotha.com/blog
www.munna.shatkotha.com
www.shatkotha.com

[Mark Rae [MVP]]

"Munna" <mu******@gmail.comwrote in message
news:73**********************************@k13g2000 hse.googlegroups.com...

Seems to be that this is problem of the client machines... your client
machines are getting out of memory...

Nothing to do with that - it's simply that server-side Office automation
isn't supported because it doesn't work properly...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"Josin John" <Jo*******@discussions.microsoft.comwrote in message
news:44**********************************@microsof t.com...

I could create MS Excel sheet using ASP.NET 2.0 with C# but it is not
being
created in some systems, following error occurs when the program compiles
:

Server-side Office Automation isn't supported by Microsoft nor is it
recommended because it doesn't work properly - Office simply wasn't designed
to be run in this way:
http://support.microsoft.com/default...US;q257757#kb2
http://support.microsoft.com/default.aspx/kb/288367

Use this instead:
http://www.aspose.com/categories/fil...a/default.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[ZSvedic]

On Jul 24, 6:10*am, Josin John <[e-mail]>
wrote:

I could create MS Excel sheet using *ASP.NET 2.0 with C# but it is not being
created
in some systems, following error occurs when the program compiles :

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 youare
saving *to.

Line of error it shows is at: workbook = workbooks.Add(Type.Missing);

OS I tried : Windows 2003 Server,Windows XP (Service Pack 2)

COM I added : MS-Excel 5.0, MS-Excel 10.0

*dcomcnfg Setting : MS-Excel->Properties->Security->Customize->Edit->Add->
* * * * * * * * * * * * * * *ASPNET->Put tick mark on Local Launch and Local
Activation

I agree with Mark that there are many automation issues on the server:
http://www.gemboxsoftware.com/GBSpre...htm#Automation

Except Aspose component, you can try GemBox.Spreadsheet Free Excel
Read/Write component: http://www.gemboxsoftware.com/GBSpreadsheetFree.htm
If you have XLS/CSV/XLSX files smaller that 150 rows it is free of
charge.

--Zeljko