Deploying Microsoft Excel Object Library 12.0

Question

0.00/5 (No votes)

See more:

, +

I am using Microsoft Excel 12.0 Object Library to use excel formula manipulation from My Site developed on .Net framework 2.0.

I have Office 2007 installed on my local machine and it works fine.

But whenever i deploy the site on to a server it shows the following error
,

The file '/forum/default.aspx' has not been pre-compiled, and cannot be requested. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.Web.HttpException: The file '/forum/default.aspx' has not been pre-compiled, and cannot be requested.
Source Error: 
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 
Stack Trace: 

[HttpException (0x80004005): The file '/forum/default.aspx' has not been pre-compiled, and cannot be requested.]
System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +826
System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +116
System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +175
System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +52
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +50
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +503
System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +142
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +263

what else i will have to do to get it working on server? and what i might be missing while building relaese for the deployment server. I am not doing anything extra for COM object while building release. what am i supposed to do?
This is my first time working with a COM object library.

Posted 22-Nov-11 19:28pm

Husmig

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2011-11-22T19:36:00

Solution 1

Office interop is not intended to be used on servers and requires the installation of the Office Suite on that server.

You are better off using server side 3rd party components for Excel file generation.

Try this : http://epplus.codeplex.com/[^]

Posted 22-Nov-11 19:36pm

Mehdi Gholam

Comments

Husmig 23-Nov-11 1:48am

Thanks for your quick response.

Does it need any other installation of assemblies or do i need to register the assemblies in GAC or just office installation is enough for the application to work?

And about epplus .... does it support the financial formulas like "PRICE", "YIELD", "YEARFRAC"?

Mehdi Gholam 23-Nov-11 1:58am

No dependencies.

It supports all the formulas in creation mode (you can write any formula in a cell) the viewer i.e. Excel will handle the computations.