摘要
简述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.
出处
《计算机与网络》
2009年第1期55-57,共3页
Computer & Network
