ASP.NET and Excel automation

[Ron]

Hey Guys,

I have an online system which use Excel 2003 to generate a report. the
system has been developed on .NET 1.1 platform and the operating
system are either windows XP or windows 2003.

the program used to work well. But recently when we run the program,
there is always an error msg says "Excel has encountered problem and
needs to be close". the Excel library version is 11. What the program
does is to create a new excel file and put some data in. The error
happens when the system create the excel file.

I tried to open the excel manually, works. Does anyone can help me
with this issue?

Thanks,

Ron

 

[Nicholas Paldino [.NET/C# MVP]]

Ron,

If you are using Excel 2003, you should be looking into creating
spreadsheet ML documents using something other than Excel. Excel is not
suited for being used in a server side environment.

If you know you are going to generate documents for Excel 2003, then I
would suggest looking into spreadsheet ML:

http://msdn2.microsoft.com/en-us/library/aa662188(office.11).aspx