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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Josin John - 24 Jul 2008 05:10 GMT

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

Reply to this Message

Munna - 24 Jul 2008 08:11 GMT

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-tutorials/generating-excel-reports.aspx

Best of luck

-------
Munna

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

Reply to this Message

Mark Rae [MVP] - 24 Jul 2008 09:10 GMT

> 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...

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

Reply to this Message

Mark Rae [MVP] - 24 Jul 2008 09:13 GMT

> 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.aspx?scid=kb;EN-US;q257757#kb2
http://support.microsoft.com/default.aspx/kb/288367

Use this instead:
http://www.aspose.com/categories/file-format-components/aspose.cells-for-.net-an
d-java/default.aspx

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

Reply to this Message

ZSvedic - 29 Jul 2008 16:45 GMT

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
[quoted text clipped - 18 lines]
> 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/GBSpreadsheet.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

Reply to this Message

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

Free Magazines