Reference Excel 2007

Question

0.00/5 (No votes)

See more:

Hi All,

I have a web application that reads in and creates excel spread sheets. I was on a server with Excel 2003/Windows 2003 and I was referencing Microsoft.Office.Interlop.Excel 11.0. The powers-to-be moved me to a server with Windows 2008 and Excel 2007 on it. I changed my reference to Excel version 12.0. It still works on my development machine but I can't create the excel file on the new server.

My references are:

add assembly="Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"
add assembly="office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"
add assembly="Microsoft.Vbe.Interop, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"

Am I missing a reference? Any help will be appreciated.

Posted 3-Jun-10 6:32am

Battlehammer

Updated 3-Jun-10 7:03am

Sandeep Mewara

v2

Add a Solution

3 solutions

Solution 1

I fixed the problem by following these instructions...

http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

but now I get this error when I try to create an excel sheet…

Unable to create Name.xlsx: 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.

Posted 3-Jun-10 7:06am

Battlehammer

Solution 3

I rebooted the server and now it works, go figure. :)

Posted 4-Jun-10 4:50am

Battlehammer

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)

Scubapro · Accepted Answer · 2010-06-03T20:07:00

Solution 2

Maybe you should use 'late binding' instead of 'early binding'.
This way, you don't have to worry about all the different versions
of Excel being used/installed.

Just Google 'create/open Excel sheet using late binding' and you'll
find numerous examples.

Posted 3-Jun-10 20:07pm

Scubapro

Comments

Battlehammer 4-Jun-10 10:52am

Thanks for the suggestion, I will implement the late binding. I wish I knew of that in the begining.