| 用Excel制作万年历的3种方法 |
| |
| 引用本文： | 王毅敏.用Excel制作万年历的3种方法[J].教育技术导刊,2019,18(7):154-158. |
| |
| 作者姓名： | 王毅敏 |
| |
| 作者单位： | 复旦大学 国家级实验教学示范中心，上海 201203 |
| |
| 摘 要： | 万年历可用高级语言编程制作，在没有现成平台的情况下，编程过程较繁琐。利用Excel提供的函数、数据公式及VBA开发功能制作万年历，阐述在Excel平台上无需编程实现万年历制作方法。用Excel制作万年历比用其它高级语言编程方法简单高效，体现了Excel强大的功能以及多途径解决问题的实用性。
|
| 关 键 词： | Excel日期函数 数组公式 VBA开发 万年历制作 |
| 收稿时间： | 2018-11-08 |
Three Methods of Making Calendars With Excel |
| |
| WANG Yi-min.Three Methods of Making Calendars With Excel[J].Introduction of Educational Technology,2019,18(7):154-158. |
| |
| Authors: | WANG Yi-min |
| |
| Institution: | National Demonstration Center for Experimental Computer Education， Fudan University， Shanghai 201203，China |
| |
| Abstract: | The calendar can be programmed in high-level language. Without an existing platform， the programming process is relative tedious. This paper introduces how to make a calendar without programming on the existing Excel platform by making use of functions provided by Excel， data formula and VBA development environment function to make a calendar， and compares it with the programming method. The three methods are making a calendar by using date function， making a calendar by using array formula and making a calendar by using VBA development tool. The first two methods do not need programming， only use Excel function nested combination and function to complete the task， the third method is programmed in Excel's own VBA development environment. The results show that it is simpler and more efficient to make calendars with Excel than other high-level languages. Making a calendar on Excel platform is a tribute to Excel's powerful function， practicability and multiple ways to solve problems. |
| |
| Keywords: | Excel date function array formula making calendar |
|
| 点击此处可从《教育技术导刊》浏览原始摘要信息 |
| 点击此处可从《教育技术导刊》下载免费的PDF全文 |
