471,065 Members | 1,301 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,065 software developers and data experts.

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


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

Jul 24 '08 #1
4 15147
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
Jul 24 '08 #2
"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

Jul 24 '08 #3
"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

Jul 24 '08 #4
On Jul 24, 6:10*am, Josin John <JosinJ...@discussions.microsoft.com>
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
Jul 29 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
3 posts views Thread by krallabandi | last post: by
reply views Thread by pmclinn | last post: by
2 posts views Thread by LittlePhil via AccessMonster.com | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.