Excel电子表格关联合并  

Join Merge of Excel Spreadsheet

作　　者：胡舜良[1] 

机构地区：[1]淮南联合大学网络信息中心

出　　处：《电脑编程技巧与维护》2010年第16期30-31,共2页Computer Programming Skills & Maintenance

摘　　要：Excel因其操作简单、使用方便,为人们进行数据管理与处理提供了非常好的平台。它内含非常丰富的函数,既能处理复杂的表格数据,也可以进行数据筛选及查询,但是实际使用中当涉及到多个表格关联筛选时,Excel就显得力不从心。利用VB.NET OleDbConnection类,将Excel电子表格作为外部数据源,通过Dataview的Rowfilter,从而实现两个Excel表格的关联合并。Excel because of its simple,easy to use,for people to deal with data management and provides a very good platform.It contains very rich functions,both dealing with complex forms of data,you can filter and query data,however,when it comes to practical use in many forms associated with screening,Excel becomes powerless.In this paper,Vb.net OleDbConnection class,the Excel spreadsheet as an external data source,through Dataview the Rowfilter,two Excel tables to achieve off the joint.

关 键 词：EXCEL电子表格 关联 合并 

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