第1章 VSTO入門概述 ················1

1.1 VSTO簡述 ·································· 1

1.1.1 VSTO的功能與特點 ······················· 1

1.1.2 VSTO開發(fā)語言 ····························· 2

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

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

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

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

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

1.2.1 控制臺應用程序 ···························· 5

1.2.2 Windows窗體應用程序 ··················· 9

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

1.3 認識Visual Studio開發(fā)環(huán)境·············11

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

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

1.3.3 【項目】菜單 ······························12

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

1.3.5 Visual Studio選項 ··························14

1.4 Visual Studio項目組織結構 ·············14

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

1.4.2 項目 ··········································17

1.4.3 類模塊 ·······································18

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

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

1.5.1 設置幫助查看方式 ························19

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

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

本章要點回顧····································21

第2章 C#語法基礎 ··················· 22

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

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

2.1.2 賦值運算符 ·································23

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

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

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

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

2.2.3 轉義字符 ····································26

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

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

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

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

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

2.3 邏輯運算 ···································29

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

2.3.2 比較運算符 ·································30

2.3.3 多條件的與或非運算 ·····················30

2.4 不同類型的強制轉換 ····················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 條件選擇語句 ·····························37

2.6.1 三元運算符 ·································37

2.6.2 if語句 ········································38

2.6.3 switch語句 ··································39

2.7 循環(huán)語句 ···································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 流程控制語句 ·····························43

2.8.1 break語句 ···································43

2.8.2 continue語句 ·······························44

2.8.3 goto語句 ····································44

2.8.4 return語句 ···································45

2.9 輸出對話框（MessageBox） ··········46

2.9.1 MessageBox語法 ··························46

2.9.2 自定義對話框的按鈕 ·····················47

2.9.3 自定義對話框的圖標 ·····················48

2.9.4 自定義對話框默認按鈕 ··················48

2.9.5 處理對話框的用戶響應 ··················48

2.10 輸入對話框（InputBox）

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

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

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

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

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

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

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

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

2.14 錯誤處理 ·································55

本章要點回顧····································56

第3章 C#進階技術 ···················57

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

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

3.1.2 文件與文件夾處理實例 ··················58

3.2 文本文件的讀寫 ··························59

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

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

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

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

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

3.5 使用正則表達式 ··························65

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

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

3.5.3 正則表達式選項 ···························66

3.5.4 正則表達式方法 ···························67

3.5.5 正則表達式測試器 ························71

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

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

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

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

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

3.6.5 去除重復 ····································74

3.7 窗體設計技術 ·····························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 使用文件選擇對話框 ·····················90

3.7.9 運行期間動態(tài)增刪控件 ··················91

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

3.8.1 窗口類名和句柄 ···························95

3.8.2

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

3.8.3

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

3.8.4 獲取光標位置 ···························· 101

本章要點回顧·································· 101

第4章 C#操作Excel對象·········· 102

4.1

Excel對象模型概述 ···················· 102

4.1.1 Application對象 ·························· 103

4.1.2 Workbook 對象 ··························· 104

4.1.3 Worksheet 對象 ··························· 104

4.1.4 Range對象 ································ 105

4.1.5 Window 對象 ······························ 105

4.2

創(chuàng)建可以訪問Excel對象的C#窗體

應用程序 ································· 105

4.2.1 添加Excel 2010對象引用 ·············· 105

4.2.2 添加Office 2010對象引用 ·············· 105

4.3 操作Application對象 ··················· 107

4.3.1 獲取正在運行的Excel對象 ············ 107

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

4.3.3 Application對象常用屬性 ·············· 109

4.3.4 Application對象常用方法 ·············· 110

4.3.5 Application對象常用事件 ·············· 110

4.3.6 Application重要集合對象 ·············· 111

4.4 操作Workbook 對象···················· 112

4.4.1 Workbook 對象常用屬性··············· 112

4.4.2 Workbook 對象常用方法··············· 113

4.4.3 Workbook 對象常用事件··············· 114

4.4.4 Workbook 重要集合對象··············· 114

4.5 操作Worksheet 對象 ···················· 115

4.5.1 Worksheet 對象常用屬性 ··············· 115

4.5.2 Worksheet 對象常用方法 ··············· 116

4.5.3 Worksheet 對象常用事件 ··············· 117

4.6 操作Range對象 ························· 117

4.6.1 Range對象常用屬性···················· 117

4.6.2 Range對象常用方法···················· 118

4.6.3 Range對象的遍歷 ······················· 119

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

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

4.7 操作Commandbar對象 ················ 121

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

4.8.1 引用VBIDE類型庫 ······················ 123

4.8.2 允許對VBA工程訪問 ·················· 123

4.8.3 操作VBE各級對象 ······················ 125

4.9

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

4.9.1

使用C#創(chuàng)建類庫 ························ 126

4.9.2

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

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

4.9.3

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

4.9.4

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

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

本章要點回顧·································· 133

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

5.1

Office COM加載項簡介 ··············· 134

5.2

認識Office COM加載項管理

對話框 ···································· 134

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

5.4 ThisAddin的啟動事件和卸載事件 ··136

本章要點回顧··································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語法規(guī)則 ···························141

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

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

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

6.3.1 選項卡（tab）元素 ·····················150

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

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

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

設計器 ····································154

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

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

6.5 使用XML進行CustomUI定制 ········159

本章要點回顧··································162

第7章 自定義任務窗格 ············163

7.1 任務窗格行為控制 ·····················163

7.2 VSTO外接程序項目中添加任務

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

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

7.2.2 添加用戶控件 ····························165

7.2.3 靜態(tài)類中聲明任務窗格對象 ··········166

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

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

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

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

7.3.2 處理自定義任務窗格事件 ·············172

7.3.3 完全卸載任務窗格 ······················173

本章要點回顧··································173

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

8.1 Office工具欄對象簡述 ················174

8.1.1 Commandbar對象 ·······················174

8.1.2 CommandbarControl對象 ··············175

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

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

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

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

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

8.2.4 卸載外接程序時清除自定義 ··········180

本章要點回顧··································181

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

9.1 客戶機搭建VSTO運行環(huán)境 ··········182

9.2 VSTO外接程序的簡單安裝 ··········183

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

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

9.3.2 客戶機運行安裝包 ······················193

本章要點回顧··································194

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

10.1 文檔自定義項編程概述 ·············195

10.2 文檔自定義項允許添加的界面

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

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

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

10.3.2 文檔項目的啟動事件過程 ···········198

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

10.5 文檔操作窗格綜合實例 ·············200

10.5.1 添加用戶控件到文檔窗格 ···········202

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

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

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

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

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

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

本章要點回顧··································211

第11章 VSTO開發(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語言的差異

對比··························222

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

12.2 嚴格的類型匹配 ······················222

12.3 項目的自動保存 ······················222

12.4 嚴格區(qū)分大小寫 ······················223

12.5 語句結束必須加分號 ················223

12.6 語句塊 ··································223

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

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

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

方括號 ··································225