Excel前提格局化对象的设计与完成(国外英语资料).docVIP

Excel条件格式化工具的设计与实现(国外英语资料) Design and implementation of Excel conditional formatting tool Abstract Excel is a spreadsheet software which is widely used in many fields. Through it, we can organize and manage the data well, analyze and analyze the data. In practical applications, we find that it is often necessary to display partial data according to a particular condition. Although this function can be implemented through Excel macros, it is uncomfortable to write similar code each time. Like other Office components, Excel provides the possibility to extend functionality through plug-ins. By writing and installing plug-ins, we can extend the functionality of Excel almost arbitrarily, providing great convenience for our work. This paper introduces the design and implementation of a Excel conditional formatting software. The software uses COM component technology, and according to the interface requirements of the Office plug-in, designed a plug-in for Excel. The plug-in adds a toolbar to the window of the Excel application and creates a button on it to open the formatting window. The software can conditional on the user input string, expression is calculated, and according to the calculation results, will satisfy the conditions for special setting unit data format is selected by the user (font, color, font size and decoration) Keywords: Excel plug-in; COM component; interface The design and implementation of Excel conditional formatting tools 1 introduction the world we live in is colorful and almost all knowledge comes from visual perception. Perhaps a string of numbers, as well as their relationships and trends, cannot be memorized. But you can easily remember a picture or a curve. Excel has many advanced graphics capabilities, and its also very convenient to use. It can be used not only to make spreadsheets, to complete many complicated data operations, but also to analyze and predict data. The Excel document is the actual work of learning is one of the most commo