Newbie Q: how to compile with VS.NET Pro 2003

[James Carlson]

Hi,

I am having a very simple problem. I am attempting to build a OWC11
application, using ASP.NET version 1.1 that will load the radius into
a target cell on an spreadsheet, then calulate all cells on the
spreadsheet, then retreive the result and display it to the user. The
code that I am attempting to use is:

Dim sp As OWC11.SpreadsheetClass = New OWC11.SpreadsheetClass
sp.XMLURL = MapPath("data\S-FELIX.xml")
sp.Range("B2").Value = Convert.ToInt32(6)
sp.CalculateFull()
Label1.Text = "Circumfrence: " & sp.Range("C2").Value

This application compiles using VS.NET 2003, however when I veiw it in
a webbrowser i get the message:

Type 'OWC11.SpreadsheetClass' is not defined.

I have followed the follwing steps to setup the server:

Setting up OWC
1. Download and install Microsoft .NET Framework Version 1.1
Redistributable Package
http://www.microsoft.com/downloads/...E3-F589-4842-8157-034D1E7CF3A3&displaylang=en
2. Download and install .NET Framework SDK Version 1.1
http://www.microsoft.com/downloads/...A6-3647-4070-9F41-A333C6B9181D&displaylang=en
3. Update the path to include
PATH=C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322;C:\Program
Files\Microsoft.NET\SDK\v1.1\Bin;%PATH%
4. Download and install OWC
http://office.microsoft.com/downloads/2002/owc10.aspx
5. Download PIA
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp
http://www.microsoft.com/downloads/...1E-3060-4F71-A6B4-01FEBA508E52&displaylang=en
change to the install directory (eg C:\oxppia) directory, and run
REGISTER.BAT
6. update teh machine.config under the <assemblies> section on the
webserver with
<add assembly="Microsoft.Office.Interop.Owc, Version=10.0.4504.0,
Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
This should be located in
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG

I have also added the follwing COM references to my VS.NET project:
Microsoft Office 11.0 Object Library
Microsoft Office 10.0 Object Library
Microsoft Office Web Components 11.0

Any help would be greatly appreciated.

Thanks,

James

 

[James Carlson]

Hi,

I am having a very simple problem. I am attempting to build a OWC11
application, using ASP.NET version 1.1 that will load the radius into
a target cell on an spreadsheet, then calulate all cells on the
spreadsheet, then retreive the result and display it to the user. The
code that I am attempting to use is:

Dim sp As OWC11.SpreadsheetClass = New OWC11.SpreadsheetClass
sp.XMLURL = MapPath("data\S-FELIX.xml")
sp.Range("B2").Value = Convert.ToInt32(6)
sp.CalculateFull()
Label1.Text = "Circumfrence: " & sp.Range("C2").Value

This application compiles using VS.NET 2003, however when I veiw it in
a webbrowser i get the message:

Type 'OWC11.SpreadsheetClass' is not defined.

I have followed the follwing steps to setup the server:

Setting up OWC
1. Download and install Microsoft .NET Framework Version 1.1
Redistributable Package
http://www.microsoft.com/downloads/...E3-F589-4842-8157-034D1E7CF3A3&displaylang=en
2. Download and install .NET Framework SDK Version 1.1
http://www.microsoft.com/downloads/...A6-3647-4070-9F41-A333C6B9181D&displaylang=en
3. Update the path to include
PATH=C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322;C:\Program
Files\Microsoft.NET\SDK\v1.1\Bin;%PATH%
4. Download and install OWC
http://office.microsoft.com/downloads/2002/owc10.aspx
5. Download PIA
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp
http://www.microsoft.com/downloads/...1E-3060-4F71-A6B4-01FEBA508E52&displaylang=en
change to the install directory (eg C:\oxppia) directory, and run
REGISTER.BAT
6. update teh machine.config under the <assemblies> section on the
webserver with
<add assembly="Microsoft.Office.Interop.Owc, Version=10.0.4504.0,
Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
This should be located in
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG

I have also added the follwing COM references to my VS.NET project:
Microsoft Office 11.0 Object Library
Microsoft Office 10.0 Object Library
Microsoft Office Web Components 11.0

Any help would be greatly appreciated.

Thanks,

James

Hey guys,

I was in corret the last step for the setup of OWC 11 was not
completed. Once I actually installed OWC everything works.

James