将excel文件导入到winform的控件中
【转】http://hi.baidu.com/fzcid/blog/item/e8abfe24af56a80a4d088d12.html
要添加引用COM中的Microsoft.office.core
然后添加命名空间System.Data.OleDb;
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
this.ofd_in.DefaultExt = "xls";
this.ofd_in.Filter = "Excel文件(*.xls)|*.xls";
}
/// <summary>
/// 从选择的excel导入
/// </summary>
/// <returns></returns>
public void ImportExcel(string ExcelName,string Tablename)
{
string strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ExcelName+";Extende