VB_NET与EXCEL进行数据处理的实现.pdfVIP

ISSN 1009-3044 E-mail: xsjl@ 与技术 年第 卷第 期（总第 期） Computer Knowledge And Technology 电脑知识 2008 4 3 30 Computer Knowledge And Technology 电脑知识与技术 Vol.4,No.3,October 2008, pp. 628-629,642 Tel:+86-551-5690963 5690964 VB.NET 与EXCEL 进行数据处理的实现 尹传光 （宿州市矿建中学，安徽宿州 234000 ） 摘要：通过对当前 软件的使用情况的调查、统计发现 对一些对有特殊要求的报表， 很难做到，比如对报表数据的自 Excel Excel Excel 动处理上，调用Excel 内部函数或者编辑一些函数有时非常麻烦。 在VB.net 进行数据处理中又发现VB.net 在对单据输出界面方面 也有很大局限， 与 的整合进行数据处理，充分利用两种软件的特长，解决了单方面使用的不足。 VB.net EXCEL 关键词： ； ；工作簿；宏；元素；集合； 类； 数组 VB.net EXCEL SortedList Array 中图分类号： 文献标识码： 文章编号： TP311 A 1009-3044(2008)30-0628-02 VB.NET and EXCEL Carry on the Data Processing the Realization YIN Chuan-guang (The Suzhou Ore Constructs The Middle School, Suzhou 234000,China) Abstract: Through to the current Excel software service condition investigation, the statistics discovered Excel to has the special request report form to some, Excel is very difficult to achieve, sometimes for instance to the report form data automatic reduction in, transfers the Excel built-in function or edits some functions extremely to trouble. Carries on in the data processing in VB.net to discover VB.net in also has the very big limitation to the documentary evidence output contact surface aspect, VB.net and the EXCEL conformity carries on the data processing, uses two kind of softwares fully the special skills, has solved the insufficiency