基于Excel的模糊筛选系统设计与实现  

Design and Implementation of Creating Fuzzy Filtering Options System Based on Excel

作　　者：王毅敏 WANG Yi-min(National Demonstration Center for Experimental Computer Education,Fudan University,Shanghai 200433,China)

机构地区：[1]复旦大学国家级实验教学示范中心,上海200433

出　　处：《软件导刊》2022年第7期68-74,共7页Software Guide

摘　　要：为提高输入效率及准确率,一般情况下,可在Excel单元格中设定选项。在特殊情况下,如选择的选项较多,则要求实现模糊筛选。由于Excel没有提供现成的模糊筛选功能,通常需要用高级语言编程实现。然而,采用Excel有关功能及函数可不用编程实现筛选,并且经过优化后,可生成一个模糊筛选系统。前台为用户提供分层的数据筛选功能,后台提供日常数据维护功能。最后结合一个实际案例,优化生成两层的模糊筛选系统。结果表明,用Excel制作模糊选项相比其它高级语言编程的方法简单且高效。在Excel平台下可生成模糊筛选系统,经过优化后可方便进行日常维护,并且界面友好、操作方便。In order to improve the efficiency and accuracy of input in Excel,options can be set in cell. In special cases,if too many options in cell should be selected,fuzzy filtering is necessary. For there is no such ready-made function in Excel,usually,it needs to be developed with high-level languages. However,the fuzzy filtering functions can be developed in Excel without programming. Moreover,after optimization,a fuzzy filtering options system can be developed. The foreground provides users with hierarchical data filtering function,the background provides daily data maintenance function. Finally,combined with a practical example,after optimization,a two-layer fuzzy filtering system is generated.The results show that the method of making fuzzy options with Excel is simpler and more efficient than that with high-level languages. The fuzzy filtering system can be generated in excel. After optimization,users can easily maintain the system,the interface of which is friendly and easy to operate.

关 键 词：EXCEL 模糊筛选 表对象 数据验证 数组公式 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]