Excel條件格式化工具的設(shè)計(jì)與實(shí)現(xiàn)

論文字?jǐn)?shù):15156,頁(yè)數(shù):30

摘要
Excel是一個(gè)在各個(gè)領(lǐng)域中被廣泛應(yīng)用的電子表格軟件。通過它，我們可以很好的組織管理數(shù)據(jù)，對(duì)數(shù)據(jù)進(jìn)行統(tǒng)計(jì)分析等。在實(shí)際應(yīng)用中，我們發(fā)現(xiàn)經(jīng)常需要根據(jù)某種特定的條件，特殊顯示部分?jǐn)?shù)據(jù)。雖然這種功能可以通過Excel宏來(lái)實(shí)現(xiàn)，但每次編寫類似的代碼使人感覺跟不方便。Excel同其它Office組件一樣，提供了通過插件進(jìn)行功能擴(kuò)展的可能。通過編寫和安裝插件，我們可以幾乎任意地?cái)U(kuò)展Excel的功能，為我們的工作提供極大的便利。本文詳細(xì)介紹了一個(gè)Excel條件格式化軟件的設(shè)計(jì)和實(shí)現(xiàn)。該軟件使用COM組件技術(shù)，根據(jù)Office插件的接口要求，設(shè)計(jì)了一個(gè)Excel的插件。該插件在Excel應(yīng)用程序的窗口中增加一個(gè)工具欄，并在其上創(chuàng)建了一個(gè)按鍵，用于打開格式化設(shè)置窗口。軟件可以對(duì)用戶輸入的、用字符串表達(dá)的判斷條件進(jìn)行計(jì)算，并根據(jù)計(jì)算結(jié)果，將滿足條件的單元數(shù)據(jù)設(shè)置為用戶選擇的特殊格式（字體、顏色、字號(hào)、修飾等）

關(guān)鍵詞：Excel插件；COM組件；接口The Design and Implementation of the Conditionally Formatting Tool for Excel
Abstract
Excel is an electronic sheet software which is extensively used in various fields. By using it, we can organize and manage data, statistically analysis data easily. In practical applications, we need it usually need to specially show some data under certain conditions. This function can be achieved by using Excel macros. However，such a method is inconvenient in writing similar codes in each time. Excel, as long as other Microsoft Office softwares, povides a standard plug-in interface, also called add-in, to allow users to expand its functionalities. By writing addins for Excel, we can almost unlimitedly to expand its functionality and makes our work more easily and effectively. This paper introduces the design and implementation of an Excel conditional formatting addin, which is implemented by the COM component technique according to the interface requirements of Excel. The conditional formatting addin adds a new Toolbar into Excel, on which there is a button to be used to open the format setting dialog. The software can calculate the results of the condition expressions inputted by the user in the form of string, and according to the result, it sets the format of the cells matching the use-defined condition to special formats (font, color, font size and decoration) that was inputted by the user.

Key words: Excel Addin; COM Component; Interface

目  錄

1引言 1
2 Com組件的實(shí)現(xiàn)技術(shù) 1
2.1 COM組件技術(shù) 1
2.2 接口 2
2.3 插件技術(shù) 3
2.4 EXCEL對(duì)象模型 4
2.4.1 Excel對(duì)象模型的類以及之間的關(guān)系 4
2.4.2 使用Excel 5
2.4.3 引用Application對(duì)象 5
2.4.4 Application對(duì)象常用的屬性、方法 6
2.4.5 使用工作薄 6
2.4.6 使用工作表 8
2.5 VB編寫組件基本介紹 9
2.5.2 在VB中編寫COM組件 9
3 Excel條件格式化工具的具體實(shí)現(xiàn) 12
3.1插件接口方法 12
3.2 Excel插件的實(shí)現(xiàn) 13
3.2.1插件實(shí)現(xiàn)的功能 13
3.2.2具體功能實(shí)現(xiàn) 13
參考文獻(xiàn) 21
致    謝 22
聲    明 23