468,134 Members | 1,278 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,134 developers. It's quick & easy.

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 14985
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
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.