VB.NET中实现Excel自动化编程  

Automation Programming of Excel in VB.NET

作　　者：王国良[1] 刘学辉[1] 冯光焰[1] 

机构地区：[1]武警石家庄指挥学院,河北石家庄050061

出　　处：《计算机与网络》2009年第1期55-57,共3页Computer & Network

摘　　要：简述VB.NET中对Excel自动化编程,详细说明其实现的技术基础、思路步骤。通过编程实例实现将数据库中数据导入Microsoft Office Excel,对Excel工作表进行格式化处理,并使用Microsoft Office Excel的内置函数进行数据处理。给出了实现此自动化功能的VB.NET程序。This paper introduces briefly the automation programming of Excel and discusses in detail the technique base and thoughts in implementation. By a VB.net program instance, the importation of data in a database into Microsoft office excel is realized, the Excel worksheets are formatted and the data processing is implemented by using the built-in functions of Microsoft office excel. This paper gives the VB.NET program which realizes the automation function.

关 键 词：VB.NET SQL数据库 EXCEL自动化 编程 

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