如何查找 Office Web 组件 (OWC) 编程文档和示例
使用 Office Web 组件参考文档
下表显示了由 Office Web 组件安装的帮助文件。要打开这些帮助文件,请在 Windows 资源管理器中定位到相应的目录,然后双击所需的文件。
组件名称 | Office Web Components 9.0 | Office XP Web Components | Office 2003 Web Components | 说明 |
---|---|---|---|---|
图表 | MSOWCDCH.chm | OWCDCH10.chm | OWCDCH11.chm | 图表组件设计时参考 |
数据透视表 | MSOWCDPL.chm | OWCDPL10.chm | OWCDPL11.chm | 数据透视表组件设计时参考 |
电子表格 | MSOWCDSS.chm | OWCDSS10.chm | OWCDSS11.chm | 电子表格组件设计时参考 |
电子表格 | MSOWCFUN.chm | OWCFUN10.chm | OWCFUN11.chm | 电子表格组件内置功能参考 |
数据源、图表、数据透视表和电子表格 | MSOWCVBA.chm | OWCVBA10.chm | OWCVBA11.chm | 所有组件的编程参考 |
注意:Office Web Components 9.0 的帮助文件默认安装在 %SystemDrive%\Program Files\Microsoft Office\Office\1033 文件夹中。Office XP Web Components 的帮助文件默认安装在 %SystemDrive%\Program Files\Common Files\Microsoft Shared\Web Components\10\1033 文件夹中。Office 2003 Web Components 的帮助文件默认安装在 %SystemDrive%:\Program Files\Common Files\Microsoft Shared\Web Components\11\1033 文件夹中。
如何序列化DataRow或者其他对象
[Serializable]
public class Field : ISerializable
{
private string name = "";
private DataRow dr = null;
private string title = "";
private int index = -1;
public class Field : ISerializable
{
private string name = "";
private DataRow dr = null;
private string title = "";
private int index = -1;
public int Index
{
get { return this.index; }
set { this.index = value; }
}
{
get { return this.index; }
set { this.index = value; }
}
public string Title
{
get { return this.title; }
set { this.title = value; }
}
{
get { return this.title; }
set { this.title = value; }
}
public string FieldName
{
get { return this.name; }
set { this.name = value; }
}
{
get { return this.name; }
set { this.name = value; }
}
public DataRow FieldInfo
{
get { return this.dr; }
set { this.dr = value; }
}
{
get { return this.dr; }
set { this.dr = value; }
}
public Field()
{
DataTable dt = new DataTable();
dt.Columns.Add("name");
this.dr = dt.NewRow();
dt.Rows.Add(dr);
}
{
DataTable dt = new DataTable();
dt.Columns.Add("name");
this.dr = dt.NewRow();
dt.Rows.Add(dr);
}
protected Field(SerializationInfo info, StreamingContext context)//特殊的构造函数,反序列化时自动调用
{
this.name = info.GetString("fieldname");
this.title = info.GetString("fieldtitle");
this.index = info.GetInt32("fieldindex");
DataTable dt = info.GetValue("fieldinfo", new DataTable().GetType()) as DataTable;
this.dr = dt.Rows[0];
}
{
this.name = info.GetString("fieldname");
this.title = info.GetString("fieldtitle");
this.index = info.GetInt32("fieldindex");
DataTable dt = info.GetValue("fieldinfo", new DataTable().GetType()) as DataTable;
this.dr = dt.Rows[0];
}
[SecurityPermissionAttribute(SecurityAction.Demand, SerializationFormatter = true)]
public virtual void GetObjectData(SerializationInfo info, StreamingContext context)//序列化时自动调用
{
info.AddValue("fieldname", this.name);
info.AddValue("fieldtitle", this.title);
info.AddValue("fieldindex", this.index);
DataTable dt = this.dr.Table.Clone(); //datarow不能同时加入到两个DataTable中,必须先克隆一个
DataRow row = dt.NewRow();
row.ItemArray = dr.ItemArray;
public virtual void GetObjectData(SerializationInfo info, StreamingContext context)//序列化时自动调用
{
info.AddValue("fieldname", this.name);
info.AddValue("fieldtitle", this.title);
info.AddValue("fieldindex", this.index);
DataTable dt = this.dr.Table.Clone(); //datarow不能同时加入到两个DataTable中,必须先克隆一个
DataRow row = dt.NewRow();
row.ItemArray = dr.ItemArray;
dt.Rows.Add(row);
info.AddValue("fieldinfo", dt, dt.GetType());
}
info.AddValue("fieldinfo", dt, dt.GetType());
}
public override string ToString()
{
return this.name;
}
}