> I would seriously reconsider the architecture of your ASP.NET
> application - IMHO loading a large process like Excel into memory and
> then accessing it from the web-server via COM is a recipe for
> disaster. Consider:
>
> * All calls from all web-pages (on potentially many threads) to
> generate the Excel file or access Excel will be serialized. You are
> creating a massive bottleneck in your web application.
>
> * You may need to configure COM out-of-process security - this can be
> tricky to get right.
>
> * Using Excel in this way to simply generate an output is not
> efficient - there are better tools for the job.
>
> Consider using:
>
>
http://www.carlosag.net/Tools/ExcelXmlWriter/>
> This creates Excel XML files, which although bulky are generated
> quickly and can be made to look good.
>
> or
>
>
http://blog.brezovsky.net/en-text-38.html>
> use the JET OLE DB Drivers to write a .csv or .xls file - just be
> careful if you are targetting 64-bit windows, as some of the drivers
> are not available.
>
> or
>
>
http://www.bytescout.com/bytescoutxls_first_steps_with_asp_net.html>
> one of many commercial products.
>
>
> Again, strongly, strongly advise against using Excel from a web
> application.
>
>
> On Dec 12, 6:42 am, "Pankaj Jain" <pan...[ at ]nagarro.com> wrote:
>> In one the web sites which we have developed, i'm creating an excel file
>> from C#.Net 2003-ASP.NET 1.1 application.
>>
>> In my local machine which runs on Windows 2003 server the application works
>> perfectly, but when I try to run
>>
>> the application in windows 2008 server machine it throws an exception at
>>
>> Exception from HRESULT: 0x800A03EC. - Microsoft.Office.Interop.Excel - at
>> Microsoft.Office.Interop.Excel.WorkbookClass.SaveAs(Object Filename, Object
>> FileFormat, Object Password, Object WriteResPassword, Object
>> ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode,
>> Object ConflictResolution, Object AddToMru, Object TextCodepage, Object
>> TextVisualLayout, Object Local)
>>
>> We have MS office 2003 installed on the windows 2008 machine.
>>
>> Regards,
>> Pankaj Jain
>