C＃访问Excel工作表 [英] C# Accessing Excel Worksheet

问题描述

 .OLEDB.4.0; + 
Data Source =+ file_path +;扩展属性= Excel 8.0;; 
  

如果是，如何访问某个工作表并插入行？

解决方案

有一篇关于codeproject的文章 - http://www.codeproject.com/KB/office/excel_using_oledb.aspx - 这应该让你开始

Is this the correct way to access a MS Office Excel 2007 file?

        String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + 
    "Data Source=" + file_path + ";Extended Properties=Excel 8.0;";

If so, how do I access a certain worksheet and insert rows? Links are also welcomed.

解决方案

There's an article on codeproject - http://www.codeproject.com/KB/office/excel_using_oledb.aspx - which should get you started

这篇关于C＃访问Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！