Why use OWC.Spreadsheet?

[PO]

We have a report application on our intranet and it's using
OWC11.Spreadsheet to display data.
The following principle is used to retrieve and display data:

<%
Set cn = Server.CreateObject("Adodb.Connetion")
Set rs = Server.CreateObject("Adodb.Recordset")

cn.Open "SomeDB"
rs.Open "SELECT SomeField FROM SomeTable;", cn
%>

Sub Window_OnLoad()
<%Do Until rs.EOF%>
Sp1.ActiveCell.Value = "<%rs.Fields("SomeField").Value%>"
Sp1.ActiveCell.Offset(1, 0).Select

<%rs.MoveNext: Loop%>
End Sub

<OBJECT id="Sp1" classid="clsid:0002E559-0000-0000-C000-000000000046">


1. Is this how it's normaly done? Or should I create Sp1 on the server, load
the data, and then assign Sp1:s HTMLData to an OWC11.Spreadsheet on the
client? In that case, why?
2. I understand that I can't use MS Excel on the server-side but, given the
above exemple, why can't I just use MS Excel directly on the webpage?

Can someone please explain to me when, in an intranet application, to use
Excel and when to use OWC.Spreadsheet?

All our clients have a Office 2003 prof. license.

Regards
PO

 

[Alvin Bruney - ASP.NET MVP]

This is one of several options. It's just that - an option - that allows you
to load data from the client. One downside is that client data is easily
viewed. If you have sensitive data like formulas for instance, you can move
the processing to the server and write an html file and load the raw data.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/

 

[PO]

Hi,

I could really use some more information about the advantages and
disadvantages using OWC on the internet.
Can you point me in the right direction?

Regards
PO

This is one of several options. It's just that - an option - that allows
you
to load data from the client. One downside is that client data is easily
viewed. If you have sensitive data like formulas for instance, you can
move
the processing to the server and write an html file and load the raw data.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

We have a report application on our intranet and it's using
OWC11.Spreadsheet to display data.
The following principle is used to retrieve and display data:

<%
Set cn = Server.CreateObject("Adodb.Connetion")
Set rs = Server.CreateObject("Adodb.Recordset")

cn.Open "SomeDB"
rs.Open "SELECT SomeField FROM SomeTable;", cn
%>

Sub Window_OnLoad()
<%Do Until rs.EOF%>
Sp1.ActiveCell.Value = "<%rs.Fields("SomeField").Value%>"
Sp1.ActiveCell.Offset(1, 0).Select

<%rs.MoveNext: Loop%>
End Sub

<OBJECT id="Sp1" classid="clsid:0002E559-0000-0000-C000-000000000046">


1. Is this how it's normaly done? Or should I create Sp1 on the server, load
the data, and then assign Sp1:s HTMLData to an OWC11.Spreadsheet on the
client? In that case, why?
2. I understand that I can't use MS Excel on the server-side but, given the
above exemple, why can't I just use MS Excel directly on the webpage?

Can someone please explain to me when, in an intranet application, to use
Excel and when to use OWC.Spreadsheet?

All our clients have a Office 2003 prof. license.

Regards
PO

 

[Alvin Bruney - ASP.NET MVP]

I'd advise you to surf the web or buy one of the OWC books available.
There's ample information in terms of resources.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

Hi,

I could really use some more information about the advantages and
disadvantages using OWC on the internet.
Can you point me in the right direction?

Regards
PO

This is one of several options. It's just that - an option - that allows
you
to load data from the client. One downside is that client data is easily
viewed. If you have sensitive data like formulas for instance, you can
move
the processing to the server and write an html file and load the raw data.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

We have a report application on our intranet and it's using
OWC11.Spreadsheet to display data.
The following principle is used to retrieve and display data:

<%
Set cn = Server.CreateObject("Adodb.Connetion")
Set rs = Server.CreateObject("Adodb.Recordset")

cn.Open "SomeDB"
rs.Open "SELECT SomeField FROM SomeTable;", cn
%>

Sub Window_OnLoad()
<%Do Until rs.EOF%>
Sp1.ActiveCell.Value = "<%rs.Fields("SomeField").Value%>"
Sp1.ActiveCell.Offset(1, 0).Select

<%rs.MoveNext: Loop%>
End Sub

<OBJECT id="Sp1" classid="clsid:0002E559-0000-0000-C000-000000000046">


1. Is this how it's normaly done? Or should I create Sp1 on the server, load
the data, and then assign Sp1:s HTMLData to an OWC11.Spreadsheet on the
client? In that case, why?
2. I understand that I can't use MS Excel on the server-side but, given the
above exemple, why can't I just use MS Excel directly on the webpage?

Can someone please explain to me when, in an intranet application, to use
Excel and when to use OWC.Spreadsheet?

All our clients have a Office 2003 prof. license.

Regards
PO