VSTO - Named Range Control Basic Operation
来源:互联网 发布:vmware player mac版 编辑:程序博客网 时间:2024/06/06 20:10
Add Named Range
Microsoft.Office.Tools.Excel.NamedRange AuthorNamedRange = null;
Excel.Range AuthorRange = this.Range["E1", "G1"];
// Setting the range name for cells
AuthorNamedRange = this.Controls.AddNamedRange(AuthorRange, "AuthorCells");
Add Change Event to Named Range
AuthorNamedRange.Change += new Excel.DocEvents_ChangeEventHandler(AuthorNamedRange_Change);
void AuthorNamedRange_Change(Excel.Range Target)
{
MessageBox.Show("123");
}
Loop through Named Range in one sheet
foreach (Microsoft.Office.Tools.Excel.NamedRange n in this.Controls.OfType<Microsoft.Office.Tools.Excel.NamedRange>())
{
string s = n.RefersToRange.AddressLocal;
}
Add Border Around
preFilledRange.BorderAround(missing, Excel.XlBorderWeight.xlThin,
Excel.XlColorIndex.xlColorIndexAutomatic, missing);
Protected (only cell "A1" can be edited)
Microsoft.Office.Tools.Excel.NamedRange namedRange2 =Controls.AddNamedRange(this.Range["A1", missing],"namedRange2");
namedRange2.Locked = false;
this.Protect("123");
- VSTO - Named Range Control Basic Operation
- linux - basic operation
- vim basic operation
- linux : libpcap basic operation
- Basic Control Containment[2]
- binary tree(basic operation)
- Basic Switch Operation 阅读笔记
- Chapter 16 Control Unit Operation
- VSTO
- VSTO
- VSTO
- Dynamic range compression/Dynamic range control
- Adding Styles to Excel sheet Range in VSTO
- operation on files named with hyphen '-'
- 比较 Microsoft Visual Basic for Applications 6.0 与 Microsoft VSTO
- VSTO中向word文档中添加Content Control 、CustomXML
- integer operation result is out of range
- basic python2(conditions & control flow)
- MAC系统使用技巧(1)
- 文件系统--mknod系统调用
- Struts2 开发流程
- uboot makefile
- CSDN一周年
- VSTO - Named Range Control Basic Operation
- [转载]关于Delphi中HInstance说明
- struts2中文件上传和下载
- 一道笔试题的搞笑解法
- java学习-JAVA基本排序法示例,JAVA数据类型转换 ,ArrayList用法,Calendar 简单应用
- WebPageTest介绍
- 浏览器工作原理
- JavaScript五种继承方式
- shader复习与深入:Normal Map(法线贴图)Ⅰ