基于C#的OLEDB和COM组件对Excel文件操作

The OLEDB and COM components operate the excel file based on C#

讨论了在C#中对Excel文件操作的两种最常用的方法:OLEDB法和COM组件法,详细地对两种方法进行了对比,分析了两种方法的特点。最后对两种方法的使用做出了总结,让用户根据不同的需求,选择不同方法,大大提高C#的工作效率。

The most commonly used two methods to operate the excellfile by C# are discussed in this paper： OLEDB and COM components. The two methods are compared in detail, analyzed characteristics. Finally two methods are summarized, allows users according to different needs, choose a different method, and improve C # efficiency greatly.