第1章 VSTO入門(mén)概述 ················1

1.1 VSTO簡(jiǎn)述 ·································· 1

1.1.1 VSTO的功能與特點(diǎn) ······················· 1

1.1.2 VSTO開(kāi)發(fā)語(yǔ)言 ····························· 2

1.1.3 VSTO開(kāi)發(fā)環(huán)境配置 ······················· 3

1.1.4 Visual Studio開(kāi)發(fā)環(huán)境 ····················· 4

1.1.5 Visual Studio版本沿革 ····················· 4

1.1.6 Visual Studio的安裝 ························ 4

1.2 創(chuàng)建第一個(gè)C#應(yīng)用程序 ················· 5

1.2.1 控制臺(tái)應(yīng)用程序 ···························· 5

1.2.2 Windows窗體應(yīng)用程序 ··················· 9

1.2.3 生成可執(zhí)行文件 ···························11

1.3 認(rèn)識(shí)Visual Studio開(kāi)發(fā)環(huán)境·············11

1.3.1 【文件】菜單 ······························12

1.3.2 【視圖】菜單 ······························12

1.3.3 【項(xiàng)目】菜單 ······························12

1.3.4 菜單欄和工具欄的自定義 ···············13

1.3.5 Visual Studio選項(xiàng) ··························14

1.4 Visual Studio項(xiàng)目組織結(jié)構(gòu) ·············14

1.4.1 解決方案 ····································14

1.4.2 項(xiàng)目 ··········································17

1.4.3 類(lèi)模塊 ·······································18

1.4.4 引用管理 ····································18

1.5 使用幫助系統(tǒng) ·····························19

1.5.1 設(shè)置幫助查看方式 ························19

1.5.2 下載和安裝Help Viewer ··················19

1.5.3 管理幫助內(nèi)容 ······························19

本章要點(diǎn)回顧····································21

第2章 C#語(yǔ)法基礎(chǔ) ··················· 22

2.1 變量的聲明和賦值 ······················22

2.1.1 常用的數(shù)據(jù)類(lèi)型 ···························22

2.1.2 賦值運(yùn)算符 ·································23

2.1.3 變量的作用范圍 ···························23

2.2 字符與字符串處理 ·······················24

2.2.1 字符變量 ····································24

2.2.2 字符串變量 ·································25

2.2.3 轉(zhuǎn)義字符 ····································26

2.2.4 字符串連接 ·································27

2.2.5 子字符串 ····································27

2.2.6 格式化字符串 ······························28

2.2.7 字符串的替換 ······························28

2.2.8 字符串與數(shù)組 ······························28

2.3 邏輯運(yùn)算 ···································29

2.3.1 布爾型變量 ·································29

2.3.2 比較運(yùn)算符 ·································30

2.3.3 多條件的與或非運(yùn)算 ·····················30

2.4 不同類(lèi)型的強(qiáng)制轉(zhuǎn)換 ····················31

2.4.1 ToString ·····································31

2.4.2 Parse ·········································31

2.4.3 Convert ······································32

2.5 使用數(shù)組 ···································33

2.5.1 數(shù)組的聲明和初始化 ·····················33

2.5.2 一維數(shù)組 ····································33

2.5.3 數(shù)組元素的遍歷 ···························34

2.5.4 二維數(shù)組 ····································35

2.6 條件選擇語(yǔ)句 ·····························37

2.6.1 三元運(yùn)算符 ·································37

2.6.2 if語(yǔ)句 ········································38

2.6.3 switch語(yǔ)句 ··································39

2.7 循環(huán)語(yǔ)句 ···································40

2.7.1 while循環(huán) ···································40

2.7.2 do循環(huán) ·······································41

2.7.3 for循環(huán) ······································42

2.7.4 foreach循環(huán)·································43

2.8 流程控制語(yǔ)句 ·····························43

2.8.1 break語(yǔ)句 ···································43

2.8.2 continue語(yǔ)句 ·······························44

2.8.3 goto語(yǔ)句 ····································44

2.8.4 return語(yǔ)句 ···································45

2.9 輸出對(duì)話框（MessageBox） ··········46

2.9.1 MessageBox語(yǔ)法 ··························46

2.9.2 自定義對(duì)話框的按鈕 ·····················47

2.9.3 自定義對(duì)話框的圖標(biāo) ·····················48

2.9.4 自定義對(duì)話框默認(rèn)按鈕 ··················48

2.9.5 處理對(duì)話框的用戶(hù)響應(yīng) ··················48

2.10 輸入對(duì)話框（InputBox）

·············49

2.11 過(guò)程與函數(shù) ······························50

2.11.1 過(guò)程與函數(shù)的定義 ······················50

2.11.2 過(guò)程與函數(shù)的調(diào)用 ······················51

2.12 類(lèi)的創(chuàng)建和使用 ························52

2.12.1 非靜態(tài)類(lèi) ··································52

2.12.2 靜態(tài)類(lèi) ·····································54

2.13 using指令 ·································55

2.14 錯(cuò)誤處理 ·································55

本章要點(diǎn)回顧····································56

第3章 C#進(jìn)階技術(shù) ···················57

3.1 文件與文件夾操作 ·······················57

3.1.1 System.IO命名空間 ·······················57

3.1.2 文件與文件夾處理實(shí)例 ··················58

3.2 文本文件的讀寫(xiě) ··························59

3.3 數(shù)據(jù)庫(kù)操作 ································60

3.4 使用資源文件 ·····························61

3.4.1 添加資源文件 ······························62

3.4.2 資源文件中的字符串 ·····················62

3.4.3 資源文件中的圖像 ························63

3.5 使用正則表達(dá)式 ··························65

3.5.1 創(chuàng)建Regex對(duì)象 ····························65

3.5.2 元字符 ·······································65

3.5.3 正則表達(dá)式選項(xiàng) ···························66

3.5.4 正則表達(dá)式方法 ···························67

3.5.5 正則表達(dá)式測(cè)試器 ························71

3.6 使用字典 ···································72

3.6.1 字典對(duì)象的創(chuàng)建 ···························72

3.6.2 根據(jù)鍵檢索值 ······························73

3.6.3 遍歷所有鍵名 ······························74

3.6.4 遍歷所有值 ·································74

3.6.5 去除重復(fù) ····································74

3.7 窗體設(shè)計(jì)技術(shù) ·····························76

3.7.1 窗體的顯示 ·································76

3.7.2 窗體的卸載 ·································77

3.7.3 窗體與控件的事件 ························78

3.7.4 使用窗體菜單 ······························82

3.7.5 使用工具欄 ·································85

3.7.6 使用右鍵菜單 ······························87

3.7.7 使用狀態(tài)欄 ·································88

3.7.8 使用文件選擇對(duì)話框 ·····················90

3.7.9 運(yùn)行期間動(dòng)態(tài)增刪控件 ··················91

3.8 使用Windows API 函數(shù) ··················94

3.8.1 窗口類(lèi)名和句柄 ···························95

3.8.2

使用Spy ··································98

3.8.3

使用UseAPI ······························ 100

3.8.4 獲取光標(biāo)位置 ···························· 101

本章要點(diǎn)回顧·································· 101

第4章 C#操作Excel對(duì)象·········· 102

4.1

Excel對(duì)象模型概述 ···················· 102

4.1.1 Application對(duì)象 ·························· 103

4.1.2 Workbook 對(duì)象 ··························· 104

4.1.3 Worksheet 對(duì)象 ··························· 104

4.1.4 Range對(duì)象 ································ 105

4.1.5 Window 對(duì)象 ······························ 105

4.2

創(chuàng)建可以訪問(wèn)Excel對(duì)象的C#窗體

應(yīng)用程序 ································· 105

4.2.1 添加Excel 2010對(duì)象引用 ·············· 105

4.2.2 添加Office 2010對(duì)象引用 ·············· 105

4.3 操作Application對(duì)象 ··················· 107

4.3.1 獲取正在運(yùn)行的Excel對(duì)象 ············ 107

4.3.2 創(chuàng)建新的Excel對(duì)象 ····················· 109

4.3.3 Application對(duì)象常用屬性 ·············· 109

4.3.4 Application對(duì)象常用方法 ·············· 110

4.3.5 Application對(duì)象常用事件 ·············· 110

4.3.6 Application重要集合對(duì)象 ·············· 111

4.4 操作Workbook 對(duì)象···················· 112

4.4.1 Workbook 對(duì)象常用屬性··············· 112

4.4.2 Workbook 對(duì)象常用方法··············· 113

4.4.3 Workbook 對(duì)象常用事件··············· 114

4.4.4 Workbook 重要集合對(duì)象··············· 114

4.5 操作Worksheet 對(duì)象 ···················· 115

4.5.1 Worksheet 對(duì)象常用屬性 ··············· 115

4.5.2 Worksheet 對(duì)象常用方法 ··············· 116

4.5.3 Worksheet 對(duì)象常用事件 ··············· 117

4.6 操作Range對(duì)象 ························· 117

4.6.1 Range對(duì)象常用屬性···················· 117

4.6.2 Range對(duì)象常用方法···················· 118

4.6.3 Range對(duì)象的遍歷 ······················· 119

4.6.4 二維數(shù)組與Range數(shù)據(jù)交換··········· 120

4.6.5 一維數(shù)組與Range數(shù)據(jù)交換··········· 121

4.7 操作Commandbar對(duì)象 ················ 121

4.8 操作VBE工程 ·························· 123

4.8.1 引用VBIDE類(lèi)型庫(kù) ······················ 123

4.8.2 允許對(duì)VBA工程訪問(wèn) ·················· 123

4.8.3 操作VBE各級(jí)對(duì)象 ······················ 125

4.9

創(chuàng)建Excel自定義函數(shù) ················· 125

4.9.1

使用C#創(chuàng)建類(lèi)庫(kù) ························ 126

4.9.2

工作表中使用C#開(kāi)發(fā)的自定義

公式 ········································ 129

4.9.3

VBA中調(diào)用C#開(kāi)發(fā)的自定義公式 ··· 131

4.9.4

C#中調(diào)用C#開(kāi)發(fā)的自定義公式 ······ 131

4.9.5 客戶(hù)機(jī)使用C#制作的自定義函數(shù) ·······132

本章要點(diǎn)回顧·································· 133

第5章創(chuàng)建Office外接程序······· 134

5.1

Office COM加載項(xiàng)簡(jiǎn)介 ··············· 134

5.2

認(rèn)識(shí)Office COM加載項(xiàng)管理

對(duì)話框 ···································· 134

5.3 創(chuàng)建第一個(gè)Office外接程序項(xiàng)目 ····135

5.4 ThisAddin的啟動(dòng)事件和卸載事件 ··136

本章要點(diǎn)回顧··································137

第6章 自定義Office功能區(qū) ·······138

6.1 CustomUI概述 ··························138

6.1.1 CustomUI的意義 ························140

6.1.2 CustomUI的作用范圍 ··················140

6.1.3 手工定制Office界面 ····················140

6.2 CustomUI與XML ·······················141

6.2.1 XML語(yǔ)法規(guī)則 ···························141

6.2.2 描述Office界面的XML ·················142

6.2.3 使用Ribbon XML Editor ···············148

6.3 CustomUI元素詳解 ····················149

6.3.1 選項(xiàng)卡（tab）元素 ·····················150

6.3.2 組（group）元素 ························151

6.3.3 控件（control）元素 ···················151

6.4 VSTO中使用功能區(qū)可視化

設(shè)計(jì)器 ····································154

6.4.1 為按鈕指定回調(diào)過(guò)程 ···················156

6.4.2 Group中加入DialogBoxLauncher ·····157

6.5 使用XML進(jìn)行CustomUI定制 ········159

本章要點(diǎn)回顧··································162

第7章 自定義任務(wù)窗格 ············163

7.1 任務(wù)窗格行為控制 ·····················163

7.2 VSTO外接程序項(xiàng)目中添加任務(wù)

窗格 ·······································164

7.2.1 創(chuàng)建Excel 2010外接程序 ··············165

7.2.2 添加用戶(hù)控件 ····························165

7.2.3 靜態(tài)類(lèi)中聲明任務(wù)窗格對(duì)象 ··········166

7.2.4 創(chuàng)建并顯示任務(wù)窗格 ···················167

7.3 功能區(qū)與任務(wù)窗格的交互控制 ······169

7.3.1 利用功能區(qū)切換按鈕控制任務(wù)窗格的

顯示隱藏 ··································169

7.3.2 處理自定義任務(wù)窗格事件 ·············172

7.3.3 完全卸載任務(wù)窗格 ······················173

本章要點(diǎn)回顧··································173

第8章 自定義工具欄 ···············174

8.1 Office工具欄對(duì)象簡(jiǎn)述 ················174

8.1.1 Commandbar對(duì)象 ·······················174

8.1.2 CommandbarControl對(duì)象 ··············175

8.1.3 自定義工具欄的作用和意義 ··········176

8.2 VSTO實(shí)現(xiàn)自定義工具欄 ·············176

8.2.1 創(chuàng)建自定義工具欄 ······················176

8.2.2 處理工具欄按鈕的回調(diào) ················178

8.2.3 修改右鍵菜單 ····························179

8.2.4 卸載外接程序時(shí)清除自定義 ··········180

本章要點(diǎn)回顧··································181

第9章 VSTO外接程序的部署分發(fā) ···182

9.1 客戶(hù)機(jī)搭建VSTO運(yùn)行環(huán)境 ··········182

9.2 VSTO外接程序的簡(jiǎn)單安裝 ··········183

9.3 使用Advanced Installer ················184

9.3.1 創(chuàng)建aip安裝包工程 ·····················184

9.3.2 客戶(hù)機(jī)運(yùn)行安裝包 ······················193

本章要點(diǎn)回顧··································194

第10章 VSTO開(kāi)發(fā)Office文檔 ···195

10.1 文檔自定義項(xiàng)編程概述 ·············195

10.2 文檔自定義項(xiàng)允許添加的界面

元素 ·····································195

10.3 創(chuàng)建Office文檔項(xiàng)目 ··················196

10.3.1 文檔上添加C#控件 ····················198

10.3.2 文檔項(xiàng)目的啟動(dòng)事件過(guò)程 ···········198

10.4 文檔操作窗格概述 ···················199

10.5 文檔操作窗格綜合實(shí)例 ·············200

10.5.1 添加用戶(hù)控件到文檔窗格 ···········202

10.5.2 添加多個(gè)相同控件到文檔窗格 ·····204

10.5.3 使用代碼創(chuàng)建窗體控件并添加到

文檔操作窗格 ··························205

10.5.4 定制功能區(qū)按鈕控制文檔操作

窗格 ······································206

10.6 文檔自定義項(xiàng)的部署分發(fā) ··········210

本章要點(diǎn)回顧··································211

第11章 VSTO開(kāi)發(fā)資源大全 ·····212

11.1 Office 2003以下版本工具欄和控件的

自定義 ··································212

11.1.1 OfficeCommandbarDesigner ··········212

11.1.2 OfficeCommandbarViewer ············213

11.1.3 FaceIDViewer ···························213

11.2 Office 2007以上版本功能區(qū)的

自定義 ··································215

11.2.1 Office2010ControlIDs ·················215

11.2.2 imageMso7345 ··························216

11.2.3 OfficeCustomUIEditor ·················217

11.2.4 Ribbon XML Editor ····················217

11.2.5 Ribbon回調(diào)函數(shù)大全 ··················217

11.3 編程環(huán)境輔助工具 ···················218

11.3.1 VBE2014 ································219

11.3.2 VisualStudioAddin2016 ···············220

第12章 C#與VB/VBA語(yǔ)言的差異

對(duì)比··························222

12.1 變量必須聲明 ·························222

12.2 嚴(yán)格的類(lèi)型匹配 ······················222

12.3 項(xiàng)目的自動(dòng)保存 ······················222

12.4 嚴(yán)格區(qū)分大小寫(xiě) ······················223

12.5 語(yǔ)句結(jié)束必須加分號(hào) ················223

12.6 語(yǔ)句塊 ··································223

12.7 調(diào)用其他函數(shù)圓括號(hào)不能少 ·······224

12.8 數(shù)組的下標(biāo)為0 ························224

12.9 數(shù)組或集合對(duì)象的索引使用

方括號(hào) ··································225