ExcelOnlineExaminationSystem | ExcelOnlineExaminationSystem-基于Excel VBA和Go语言的自动化考试系统

ExcelOnlineExaminationSystem is a Go library. ExcelOnlineExaminationSystem has no bugs, it has no vulnerabilities and it has low support. You can download it from GitHub.

软件学报ISSN 1000-9825, CODEN RUXUEW E-mail: jos\@iscas.ac.cn. Journal of Software, [doi: 10.13328/j.cnki.jos.000000] 1(青海大学 计算机技术与应用系,青海 西宁 810000). 通讯作者: 李怡龙, E-mail: leeli\@live.cn. 摘 要: 针对期末考试任务繁重、考试系统依赖环境多安装复杂等情况，开发了前端基于EXCEL使用VBA语言、后端基于Go语言的自动化考试系统，实现了无纸化上机考试、结果批改和作弊检测一体，并给出了一种通用Microsoft Excel自动化考试系统的设计方法及通用的考试服务器及相关API接口，本文主要介绍了系统构成与功能实现. 中文引用格式: 李怡龙.基于Excel VBA和Go语言的自动化考试系统.软件学报. xxxx.htm. 英文引用格式: Li Yilong. Automated Examination System Based on Excel VBA and Go Language. Ruan Jian Xue Bao/Journal of Software, 2019 (in Chinese). Automated Examination System Based on Excel VBA and Go Language. 1(Department of Computer Technology and Applications, QingHai University, QingHai 810000, China). Abstract: Aiming at the heavy task of final examination and the complex installation of examination system depending on environment, an automated examination system based on EXCEL using VBA language at the front end and Go language at the back end is developed, which realizes the integration of paperless computer examination, result correction and cheating detection. A general design method of Microsoft Excel automated examination system and a general test server are given. Related API interface, this paper mainly introduces the system structure and function realization. Key words: Excel;Examination System;Golang;Excel VBA. Visual Basic for Applications（VBA）是Visual Basic的一种宏语言，是微软开发出来在其桌面应用程序中执行通用的自动化(OLE)任务的编程语言。主要能用来扩展Windows的应用程序功能，特别是Microsoft Office软件。也可说是一种应用程式视觉化的Basic 脚本。该语言于1993年由微软公司开发的的应用程序共享一种通用的自动化语言--------Visual Basic for Application(VBA)，实际上VBA是寄生于VB应用程序的版本。微软在1994年发行的Excel5.0版本中，即具备了VBA的宏功能.