| VB．NET中实现Excel自动化编程 |
| |
| 引用本文： | 王国良,刘学辉,冯光焰. VB．NET中实现Excel自动化编程[J]. 计算机与网络, 2009, 0(1): 55-57 |
| |
| 作者姓名： | 王国良 刘学辉 冯光焰 |
| |
| 作者单位： | 武警石家庄指挥学院,河北石家庄050061 |
| |
| 摘 要： | 简述VB．NET中对Excel自动化编程，详细说明其实现的技术基础、思路步骤。通过编程实例实现将数据库中数据导入Microsoft Office Excel，对Excel工作表进行格式化处理，并使用Microsoft Office Excel的内置函数进行数据处理。给出了实现此自动化功能的VB．NET程序。
|
| 关 键 词： | VB.NET SQL数据库 Excel自动化 编程 |
Automation Programming of Excel in VB.NET |
| |
| WANG Guo-liang,LIU Xue-hui,FENG Guang-yan. Automation Programming of Excel in VB.NET[J]. China Computer & Network, 2009, 0(1): 55-57 |
| |
| Authors: | WANG Guo-liang LIU Xue-hui FENG Guang-yan |
| |
| Affiliation: | (Shijiazhuang Commanding Academy of Chinese People＇s Armed Police Force,Shijiazhuang Hebei 050061, China) |
| |
| Abstract: | 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. |
| |
| Keywords: | VB.net SQL Database Excel automation programming |
| 本文献已被 维普 等数据库收录！ |
