Excel Data Import into Database Analysis Based on Instruction System

WANG Yun-fu; WU Shang; ZHANG Xiao-ru

Chinese

您当前的位置：

首页 >

文章列表页 >

Excel Data Import into Database Analysis Based on Instruction System

更新时间：2026-09-04

- Excel Data Import into Database Analysis Based on Instruction System
- Vol. 31, Issue 9, Pages: 162-166(2014)
- 作者机构：
  
  江苏科技大学机构计算机科学与工程学院,江苏,镇江,212000
- 作者简介：
- 基金信息：
- DOI：
  CLC：
- Published：2014
- 稿件说明：
移动端阅览
王允富, 武尚, 张晓如. 基于指令系统的Excel数据导入数据库方法研究[J]. 微电子学与计算机, 2014, 31(9): 162-166.

WANG Yun-fu, WU Shang, ZHANG Xiao-ru. Excel Data Import into Database Analysis Based on Instruction System[J]. 2014, 31(9): 162-166.
王允富, 武尚, 张晓如. 基于指令系统的Excel数据导入数据库方法研究[J]. 微电子学与计算机, 2014, 31(9): 162-166. DOI：

WANG Yun-fu, WU Shang, ZHANG Xiao-ru. Excel Data Import into Database Analysis Based on Instruction System[J]. 2014, 31(9): 162-166. DOI：

摘要

针对现有Excel数据导入数据库方法通用性不够的问题

提出并实现了一种基于指令系统的通用的数据导入方法.设计了一套用于Excel数据抽取的指令系统

给不同的Excel表一个可配置的指令文件

通过指令解释器解析该配置文件

便可自动完成Excel数据的抽取、及其数据向数据库的导入工作.实践证明

该套指令系统具有非常好的通用性.

Abstract

A versatile data import method

based on instruction system

has been put forward to solve the problem of lack of versatility in methods for the Excel data into the database at present.We designed a set of instruction system for Excel data extraction

which provides different Excel table with a configurable command file that could be parsed by the command interpreter so as to finish Excel data extraction and data import into database automatically.Practical application shows that the instruction system has good versatility.

关键词

Keywords

references

Views

下载量

CSCD

Alert me when the article has been cited

提交

Tools

Publicity Resources

Research on the design of blockchain-based AI-generated content traceability framework

Design of ultra-low power real-time clock circuits

Implementation and verification of a dual-chain power gating strategy for low power design

Monte carlo analysis of V-layout trench SiC neutron detector

Lightweight countermeasures against Spectre attacks on the branch prediction unit

Related Author

No data

Related Institution

No data

AI问答

Postal code：100079
Tel：（010）53879206 Email：tmw@bjxintong.com.cn
Technical support is provided by Beijing Founder electronics co., LTD 京ICP备09082226号-64 京公网安备11010602201714号
It is recommended to read the content of this site in Chrome&IE9+. Please switch to extreme mode in browser 360.
Cookies We use cookies to help provide and enhance our service and tailor content. By continuing, you agree to the use of cookies.

⁰