Client Side Control and OWC Object

[DougB]

Hi,

Is it be possible to reference an OWC excel spreadsheet object embedded in
an HTML page(for instance "id=Spreadsheet1") from a client side control
(.dll) object embedded in the same html page(I'm working with VS.NET)?. If
so, can you please explain the basics?

Note: In my project I can't seem to get the Windows control to recognize the
OWC SS component embedded in the html page, is there is a reference i need to
set while working on the project?

Thanks in advance!
Dougb

 

[Alvin Bruney - ASP.NET MVP]

Sure you can, there are examples of this in the black book. However, you
speak of windows controls

Note: In my project I can't seem to get the Windows control to recognize

the
I'm unclear as to how the two are related. Please explain.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[DougB]

Thanks Alvin! I ordered your book within minutes of finding it from LuLu (but
won't receive it for several days)!

I'm building a client side (web) control in vs.net by selecting "Windows
Control Library" for the project to create a .dll. The .dll object will be
referenced in a web page requiring Excel functionality. If I embed the OWC
spreadsheet directly into a .net form the project references several .dll's
which (i assume) all need to get downloaded to the client. I'd prefer to
embed the OWC spreadsheet object into the html page and then reference it
from the control embedded in the same .html page(that's the part i cant
figure out). In that case will I require only 1 .dll to download to the
client?

Just one more q.. what happens if a (client web control) project references
several .dlls? Does each require its own object tag in order to get
downloaded to the GAC/download folder?

Sincerely,
dougb

Is that okay? that will get downloaded to the client's machine when
referenced from the html object tag.

Sure you can, there are examples of this in the black book. However, you
speak of windows controls

Note: In my project I can't seem to get the Windows control to recognize

the
I'm unclear as to how the two are related. Please explain.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi,

Is it be possible to reference an OWC excel spreadsheet object embedded in
an HTML page(for instance "id=Spreadsheet1") from a client side control
(.dll) object embedded in the same html page(I'm working with VS.NET)?. If
so, can you please explain the basics?

Note: In my project I can't seem to get the Windows control to recognize the
OWC SS component embedded in the html page, is there is a reference i need to
set while working on the project?

Thanks in advance!
Dougb

 

[Alvin Bruney - ASP.NET MVP]

A windows control library doesn't have a GUI, so you won't be able to show
the spreadsheet. That's find if you only intend to use the spreadsheet as an
in-memory object. Otherwise, you are going down the wrong path.

The only library required by the OWC is the OWC dll. The other assemblies
are not related to OWC and don't need to be included. I'll amend that
discussion to assume you have the PIA's installed already, if you don't they
aren't necessarily required but should be installed to avoid some nasty
issues.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Thanks Alvin! I ordered your book within minutes of finding it from LuLu (but
won't receive it for several days)!

I'm building a client side (web) control in vs.net by selecting "Windows
Control Library" for the project to create a .dll. The .dll object will be
referenced in a web page requiring Excel functionality. If I embed the OWC
spreadsheet directly into a .net form the project references several ..dll's
which (i assume) all need to get downloaded to the client. I'd prefer to
embed the OWC spreadsheet object into the html page and then reference it
from the control embedded in the same .html page(that's the part i cant
figure out). In that case will I require only 1 .dll to download to the
client?

Just one more q.. what happens if a (client web control) project references
several .dlls? Does each require its own object tag in order to get
downloaded to the GAC/download folder?

Sincerely,
dougb

Is that okay? that will get downloaded to the client's machine when
referenced from the html object tag.

Sure you can, there are examples of this in the black book. However, you
speak of windows controls

Note: In my project I can't seem to get the Windows control to

recognize
the
I'm unclear as to how the two are related. Please explain.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi,

Is it be possible to reference an OWC excel spreadsheet object embedded in
an HTML page(for instance "id=Spreadsheet1") from a client side control
(.dll) object embedded in the same html page(I'm working with VS.NET)?. If
so, can you please explain the basics?

Note: In my project I can't seem to get the Windows control to

recognize
the

OWC SS component embedded in the html page, is there is a reference i

need
to

set while working on the project?

Thanks in advance!
Dougb

 

[Alvin Bruney - ASP.NET MVP]

Right, so these are the interop assemblies. They act as middle men between
the OWC and the Office API. So are you using this as a thin-client because
you mention axInterop and IE in the same sentence. If you aren't, you've
definitely taken a wrong turn somewhere.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi Alvin,

The following 2 .dll's always come down regardless when the client side owc
control is referenced in IE; AxInterop.OWC11.dll & Interop.OWC11.dll.
Interestingly after I got everything working I am now unable to load the OWC
SpreadSheet object in any of my VS.NET projects; I receive the following
error "One or more types in the assembly unable to load". Despite my best
attempts to repair office and reinstall OWC11 i'm not having any luck getting
this working again. Can you offer any suggestion?

Thanks for all your help, still waiting for LuLu to send out the OWC black
book.

Regards,
dougb

Hold on, the way you are using it is in-memory (no gui). So you can either
simply have that call inside the library code or place the owc object
htmlurl load call in its own library. Either way, it doesn't make a
difference. Now, if you decide to put it in its own library, you should note
that only one assembly is needed for it to compile (owc[version].dll). That
dll is all you need in your projects. That dll should placed in the server
directory and you should be fine. The other assemblies that are being
referenced are not related to the office web components.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Alvin,
I simply created a new "form class" that creates a form. After the ..dll
loads in the web page I then create a new form object(invisibly). Is that
what you refer to as "In-Memory"? Anyway, this worked but only after I remmed
the lines of code referencing the ".resx" (xml) file. Is that okay or do i
have to create a ".resx" file for any reason?

Sincerely,
Doug

:

A windows control library doesn't have a GUI, so you won't be able

to
show

the spreadsheet. That's find if you only intend to use the

spreadsheet
as an

in-memory object. Otherwise, you are going down the wrong path.

The only library required by the OWC is the OWC dll. The other assemblies
are not related to OWC and don't need to be included. I'll amend that
discussion to assume you have the PIA's installed already, if you

don't
they

aren't necessarily required but should be installed to avoid some nasty
issues.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



Thanks Alvin! I ordered your book within minutes of finding it

from
LuLu

(but
won't receive it for several days)!

I'm building a client side (web) control in vs.net by selecting "Windows
Control Library" for the project to create a .dll. The .dll object will be
referenced in a web page requiring Excel functionality. If I embed

the
OWC

spreadsheet directly into a .net form the project references several
..dll's
which (i assume) all need to get downloaded to the client. I'd

prefer
to

embed the OWC spreadsheet object into the html page and then

reference
it

from the control embedded in the same .html page(that's the part i cant
figure out). In that case will I require only 1 .dll to download

to
the

client?

Just one more q.. what happens if a (client web control) project
references
several .dlls? Does each require its own object tag in order to get
downloaded to the GAC/download folder?

Sincerely,
dougb

Is that okay? that will get downloaded to the client's machine when
referenced from the html object tag.

:

Sure you can, there are examples of this in the black book.

However,
you

speak of windows controls
Note: In my project I can't seem to get the Windows control to
recognize
the
I'm unclear as to how the two are related. Please explain.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



Hi,

Is it be possible to reference an OWC excel spreadsheet object
embedded in
an HTML page(for instance "id=Spreadsheet1") from a client side
control
(.dll) object embedded in the same html page(I'm working with
VS.NET)?. If
so, can you please explain the basics?

Note: In my project I can't seem to get the Windows control to
recognize
the
OWC SS component embedded in the html page, is there is a reference i
need
to
set while working on the project?

Thanks in advance!
Dougb