由如上一次的问题依然没有解决,所以重发帖,不惜高分再次求解========================================================a.aspx ( HTML Code Summary )
----------------------------------------------------------------------------------
<%@ Page language="vb" AutoEvent="false" Codebehind="a.aspx.vb" Inherits=.......%>
<html>
....
.....<body>
<form id="form1" runat="server" method="post">
<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="Spreadsheet1"
width="100%" height="100%">
<param name="HTMLURL" value>
<param name="HTMLData"
value="<html xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
.......
.......
<x:Caption>Documet Receving and Checking</x:Caption>
.......">
</object>
</form>
</body>
</html>
----------------a.aspx end -------------------------------------------------------------------a.aspx.vb -----------------------------------------------------
imports OWC
imports System
imports System.Web.UI
imports System.Web.UI.WebControls
imports System.Drawing
imports system.text
imports system.Data.OleDb
imports System.Data.SqlClientpublic class a
Inherits System.web.ui.page protected withevents Spreadsheet1 as Owc.Spreadsheet =new Owc.Spreadsheet
'rem protected withevents Spreadsheet1 as Owc.SpreadsheetClass =new Owc.SpreadsheetClass ......
......
private sub Page_Load(......) handler Mybase.load
'the result is -->Microsoft Office SpreadSheet
'but a.aspx page spreadsheet1's catpion is -->Documet Receving and Checking
response.write Spreadsheet1.titlebar.caption.toString() '所以a.aspx中的SpreadSheet1和a.aspx.vb中的Spreadsheet1是不同的对象
(为什么会这样 ??? ,如何解决 ??)
'而且 a.aspx.vb中的Spreadsheet1在后台隐藏 (问题: 如何显示出来 ??? )
end sub......
.....
....
准确地说:
一个在客户端允运行,一个在服务器端
我的需求
用spreadsheet作为一个界面 实现以下功能
1> 将database 中的记录 显示在 spreadsheet 中 (dataset 绑定)
2> spreadsheet 可由用户编辑
(Inter multi recrods ,Delete Multi records, Modify Multi record)
后台捕获spreadsheet的相应事件并作相应的处利)
-------------------------------------------------------------------
因此OWC.Spreadsheet (在服务器端)会比较好
,因为在服务器端能很好的控制到Spreadsheet,但是owc.spreadsheet的真容(界面)
却显示不出来(这是问题的关键--如何将后台隐藏的Spreadsheet显示在a.aspx页面中)
接前面的帖如下:
cw888() 的回复
=======================================================================================
1,a.aspx中的SpreadSheet1是ActiveX控件的声明调用格式!
而在a.aspx.vb中的Spreadsheet1中又重新new一个新对象
因此是俩个不同的对象。
2,我的方案:先在a.aspx头中注册
如:<%@ Register TagPrefix="Spreadsheet1" Namespace="Owc.Spreadsheet" Assembly="Owc.Spreadsheet, Version=2.0.1.0, Culture=neutral, PublicKeyToken=a5fa960294d899e7" %>
再a.aspx的body中
<Spreadsheet1:SheetView>
........</Spreadsheet1:fpspread>
SheetView是Spreadsheet1下的类
3,a.aspx.vb中
声明:protected Owc.Spreadsheet Spreadsheet1;在a.aspx.vb函数中就可操作Spreadsheet1对象了,并且显示也是同一个对象
我是做过的:只是我们的版本不一样而已。<farpoint:fpspread id="FpSpread1" style="Z-INDEX: 101; LEFT: 160px; POSITION: absolute; TOP: 104px" runat="server" width="448px" height="223px" borderstyle="Solid" isprint="False" designstring='<?xml version="1.0" encoding="utf-8"?><Spread />' borderwidth="1px" bordercolor="Black" enableclientscript="False" enabled="False">
<sheets>
<farpoint:SheetView DesignString="<?xml version="1.0" encoding="utf-8"?><Sheet><Data><RowHeader class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="3" columns="1"><AutoCalculation>True</AutoCalculation><AutoGenerateColumns>True</AutoGenerateColumns><ReferenceStyle>A1</ReferenceStyle><Iteration>False</Iteration><MaximumIterations>1</MaximumIterations><MaximumChange>0.001</MaximumChange></RowHeader><ColumnHeader class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="1" columns="4"><AutoCalculation>True</AutoCalculation><AutoGenerateColumns>True</AutoGenerateColumns><ReferenceStyle>A1</ReferenceStyle><Iteration>False</Iteration><MaximumIterations>1</MaximumIterations><MaximumChange>0.001</MaximumChange></ColumnHeader><DataArea class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="3" columns="4"><AutoCalculation>True</AutoCalculation><AutoGenerateColumns>True</AutoGenerateColumns><ReferenceStyle>A1</ReferenceStyle><Iteration>False</Iteration><MaximumIterations>1</MaximumIterations><MaximumChange>0.001</MaximumChange></DataArea></Data><Presentation><AxisModels><Column class="FarPoint.Web.Spread.Model.DefaultSheetAxisModel" orientation="Horizontal" count="4"><Items><Item index="-1"><SortIndicator>Ascending</SortIndicator></Item></Items></Column><RowHeaderColumn class="FarPoint.Web.Spread.Model.DefaultSheetAxisModel" defaultSize="40" orientation="Horizontal" count="1"><Items><Item index="-1"><Size>40</Size><SortIndicator>Ascending</SortIndicator></Item></Items></RowHeaderColumn><ColumnHeaderRow class="FarPoint.Web.Spread.Model.DefaultSheetAxisModel" defaultSize="22" orientation="Vertical" count="1"><Items><Item index="-1"><Size>22</Size></Item></Items></ColumnHeaderRow></AxisModels><StyleModels><RowHeader class="FarPoint.Web.Spread.Model.DefaultSheetStyleModel" Rows="3" Columns="1"><AltRowCount>2</AltRowCount><DefaultStyle class="FarPoint.Web.Spread.NamedStyle" Parent="HeaderDefault" /></RowHeader><ColumnHeader class="FarPoint.Web.Spread.Model.DefaultSheetStyleModel" Rows="1" Columns="4"><AltRowCount>2</AltRowCount><DefaultStyle class="FarPoint.Web.Spread.NamedStyle" Parent="HeaderDefault" /></ColumnHeader><DataArea class="FarPoint.Web.Spread.Model.DefaultSheetStyleModel" Rows="3" Columns="4"><AltRowCount>2</AltRowCount><DefaultStyle class="FarPoint.Web.Spread.NamedStyle" Parent="DataAreaDefault" /></DataArea></StyleModels><MessageRowStyle class="FarPoint.Web.Spread.Appearance"><BackColor>LightYellow</BackColor><ForeColor>Red</ForeColor></MessageRowStyle><SheetCornerStyle class="FarPoint.Web.Spread.NamedStyle" Parent="HeaderDefault" /></Presentation></Sheet>" SheetName="Sheet1">
<rowheader width="40">
</RowHeader>
</farpoint:SheetView>
</Sheets>
</farpoint:fpspread>
我的源代码是这样的,其中fpspread就是你的Spreadsheet1
在函数中调用
private void Page_Load(object sender, System.EventArgs e)
{
FpSpread1.ActiveSheetView.AllowSort = true;
}
在页面能设计Spread的属性
To :cw888文中的FarPoint 是指什么 ?? ( 不会是第三方组件吧 )
==================================================================================
请大家来参与
----------------------------------------------------------------------------------
<%@ Page language="vb" AutoEvent="false" Codebehind="a.aspx.vb" Inherits=.......%>
<html>
....
.....<body>
<form id="form1" runat="server" method="post">
<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="Spreadsheet1"
width="100%" height="100%">
<param name="HTMLURL" value>
<param name="HTMLData"
value="<html xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
.......
.......
<x:Caption>Documet Receving and Checking</x:Caption>
.......">
</object>
</form>
</body>
</html>
----------------a.aspx end -------------------------------------------------------------------a.aspx.vb -----------------------------------------------------
imports OWC
imports System
imports System.Web.UI
imports System.Web.UI.WebControls
imports System.Drawing
imports system.text
imports system.Data.OleDb
imports System.Data.SqlClientpublic class a
Inherits System.web.ui.page protected withevents Spreadsheet1 as Owc.Spreadsheet =new Owc.Spreadsheet
'rem protected withevents Spreadsheet1 as Owc.SpreadsheetClass =new Owc.SpreadsheetClass ......
......
private sub Page_Load(......) handler Mybase.load
'the result is -->Microsoft Office SpreadSheet
'but a.aspx page spreadsheet1's catpion is -->Documet Receving and Checking
response.write Spreadsheet1.titlebar.caption.toString() '所以a.aspx中的SpreadSheet1和a.aspx.vb中的Spreadsheet1是不同的对象
(为什么会这样 ??? ,如何解决 ??)
'而且 a.aspx.vb中的Spreadsheet1在后台隐藏 (问题: 如何显示出来 ??? )
end sub......
.....
....
准确地说:
一个在客户端允运行,一个在服务器端
我的需求
用spreadsheet作为一个界面 实现以下功能
1> 将database 中的记录 显示在 spreadsheet 中 (dataset 绑定)
2> spreadsheet 可由用户编辑
(Inter multi recrods ,Delete Multi records, Modify Multi record)
后台捕获spreadsheet的相应事件并作相应的处利)
-------------------------------------------------------------------
因此OWC.Spreadsheet (在服务器端)会比较好
,因为在服务器端能很好的控制到Spreadsheet,但是owc.spreadsheet的真容(界面)
却显示不出来(这是问题的关键--如何将后台隐藏的Spreadsheet显示在a.aspx页面中)
接前面的帖如下:
cw888() 的回复
=======================================================================================
1,a.aspx中的SpreadSheet1是ActiveX控件的声明调用格式!
而在a.aspx.vb中的Spreadsheet1中又重新new一个新对象
因此是俩个不同的对象。
2,我的方案:先在a.aspx头中注册
如:<%@ Register TagPrefix="Spreadsheet1" Namespace="Owc.Spreadsheet" Assembly="Owc.Spreadsheet, Version=2.0.1.0, Culture=neutral, PublicKeyToken=a5fa960294d899e7" %>
再a.aspx的body中
<Spreadsheet1:SheetView>
........</Spreadsheet1:fpspread>
SheetView是Spreadsheet1下的类
3,a.aspx.vb中
声明:protected Owc.Spreadsheet Spreadsheet1;在a.aspx.vb函数中就可操作Spreadsheet1对象了,并且显示也是同一个对象
我是做过的:只是我们的版本不一样而已。<farpoint:fpspread id="FpSpread1" style="Z-INDEX: 101; LEFT: 160px; POSITION: absolute; TOP: 104px" runat="server" width="448px" height="223px" borderstyle="Solid" isprint="False" designstring='<?xml version="1.0" encoding="utf-8"?><Spread />' borderwidth="1px" bordercolor="Black" enableclientscript="False" enabled="False">
<sheets>
<farpoint:SheetView DesignString="<?xml version="1.0" encoding="utf-8"?><Sheet><Data><RowHeader class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="3" columns="1"><AutoCalculation>True</AutoCalculation><AutoGenerateColumns>True</AutoGenerateColumns><ReferenceStyle>A1</ReferenceStyle><Iteration>False</Iteration><MaximumIterations>1</MaximumIterations><MaximumChange>0.001</MaximumChange></RowHeader><ColumnHeader class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="1" columns="4"><AutoCalculation>True</AutoCalculation><AutoGenerateColumns>True</AutoGenerateColumns><ReferenceStyle>A1</ReferenceStyle><Iteration>False</Iteration><MaximumIterations>1</MaximumIterations><MaximumChange>0.001</MaximumChange></ColumnHeader><DataArea class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="3" columns="4"><AutoCalculation>True</AutoCalculation><AutoGenerateColumns>True</AutoGenerateColumns><ReferenceStyle>A1</ReferenceStyle><Iteration>False</Iteration><MaximumIterations>1</MaximumIterations><MaximumChange>0.001</MaximumChange></DataArea></Data><Presentation><AxisModels><Column class="FarPoint.Web.Spread.Model.DefaultSheetAxisModel" orientation="Horizontal" count="4"><Items><Item index="-1"><SortIndicator>Ascending</SortIndicator></Item></Items></Column><RowHeaderColumn class="FarPoint.Web.Spread.Model.DefaultSheetAxisModel" defaultSize="40" orientation="Horizontal" count="1"><Items><Item index="-1"><Size>40</Size><SortIndicator>Ascending</SortIndicator></Item></Items></RowHeaderColumn><ColumnHeaderRow class="FarPoint.Web.Spread.Model.DefaultSheetAxisModel" defaultSize="22" orientation="Vertical" count="1"><Items><Item index="-1"><Size>22</Size></Item></Items></ColumnHeaderRow></AxisModels><StyleModels><RowHeader class="FarPoint.Web.Spread.Model.DefaultSheetStyleModel" Rows="3" Columns="1"><AltRowCount>2</AltRowCount><DefaultStyle class="FarPoint.Web.Spread.NamedStyle" Parent="HeaderDefault" /></RowHeader><ColumnHeader class="FarPoint.Web.Spread.Model.DefaultSheetStyleModel" Rows="1" Columns="4"><AltRowCount>2</AltRowCount><DefaultStyle class="FarPoint.Web.Spread.NamedStyle" Parent="HeaderDefault" /></ColumnHeader><DataArea class="FarPoint.Web.Spread.Model.DefaultSheetStyleModel" Rows="3" Columns="4"><AltRowCount>2</AltRowCount><DefaultStyle class="FarPoint.Web.Spread.NamedStyle" Parent="DataAreaDefault" /></DataArea></StyleModels><MessageRowStyle class="FarPoint.Web.Spread.Appearance"><BackColor>LightYellow</BackColor><ForeColor>Red</ForeColor></MessageRowStyle><SheetCornerStyle class="FarPoint.Web.Spread.NamedStyle" Parent="HeaderDefault" /></Presentation></Sheet>" SheetName="Sheet1">
<rowheader width="40">
</RowHeader>
</farpoint:SheetView>
</Sheets>
</farpoint:fpspread>
我的源代码是这样的,其中fpspread就是你的Spreadsheet1
在函数中调用
private void Page_Load(object sender, System.EventArgs e)
{
FpSpread1.ActiveSheetView.AllowSort = true;
}
在页面能设计Spread的属性
To :cw888文中的FarPoint 是指什么 ?? ( 不会是第三方组件吧 )
==================================================================================
请大家来参与
解决方案 »
- 求把自己的商业网集成支付宝借口的相关流程
- 请问错误提示The GridView 'GridView1' fired event RowDeleting which wasn't handled的是因为什么造成的?
- 请问,弹出一个框架页面,怎么关闭框架,然后刷新父页面。
- 100分全押了,怎么获得dts包执行过程中的状态?
- datagrid 中的ImageButton 删除一条数据对话框提示?急!!!
- 修改了.aspx.bak文件,但是运行时还是现实原来的页面!各位大哥帮忙
- 如何从客户端上传大量数据到服务器?
- 客户端运行的代码能否得到服务器上的数据?
- 请介绍几个用ASP.NET建的中文网站!
- 在win2003 IIS6 下一切正常的web程序,挪到 winserver2008 R2 64位服务器系统,IIS7.5 下,提示web.config 错
- 大型门户网站,如何提升其速度。有经验的兄弟讲讲。分享下你的经验。
- 有用过ASP.NET Forum的吗, 据说他是微软写的?
客户端的例子
http://www.hedgerwow.com/BLOG/owc/OWCMain.htm
http://www.eggheadcafe.com/articles/20030725.asp
谢谢你
------------
因为我想用spreadsheet来作为一个用户交互的界面,所以
1 需要捕获用户在Spreadsheet中所作的动作
(如 :
插入新记录 (可能是插入多条记录 eg: 用户通过copy - paste 的方式 )
删除记录
更新记录
) 所以我觉得 通过owc.spreadsheet 对象在server端容易控制界面的数据变化
-----如果通过Client : javascript/vbscript 来操作 <object id="spreadsheet"
classid="......." viewtext> 可能困难性会更大( 更多的是我缺少相关的
information )
2 通过dataset 来将SQL Database中的记录绑顶到spreadsheet中显示在页面上相对容易
操作
-----如果通过Client : javascript/vbscript 来操作 <object id="spreadsheet"
classid="......." viewtext> ,需要通过将dataset 映射到Client端
有点麻烦)这是我对client 操作zpreadsheet所担心的地方,如果孟子哥哥觉悟我的想法不对,请
再次指出
=================================================================================