C# Winform读取Excel

来源：互联网发布：mac进不了安全模式编辑：程序博客网时间：2024/06/06 16:31

在 WinForm中打开Excel
添加 openFileDialog（openFileDialogSource）和 toolStrip 和ComboBox(ctlPath) 控件

//代码：DataTable dTable;// 打开 private void buttonOpen_Click(object sender, EventArgs e)        {            if (openFileDialogSource.ShowDialog()==DialogResult.OK)            {                ctlPath.Text = openFileDialogSource.FileName;                 ExceltoDataSet(ctlPath.Text);            }        }//打开方法 public DataTable ExceltoDataSet(string path)        {            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";            OleDbConnection conn = new OleDbConnection(strConn);            conn.Open();            System.Data.DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);            string tableName = schemaTable.Rows[0][2].ToString().Trim();            string strExcel = "";            OleDbDataAdapter myCommand = null;            DataSet ds = null;            strExcel = "Select   *   From   [" + tableName + "]";            myCommand = new OleDbDataAdapter(strExcel, strConn);            ds = new DataSet();            myCommand.Fill(ds, tableName);            System.Data.DataTable dt = ds.Tables[0];                        dTable = dt;            return dt;        }  //显示数据private void tsbRefresh_Click(object sender, EventArgs e)        {            if (string.IsNullOrEmpty(ctlPath.Text))            {                ctlPath.Focus();                return;            }            try            {                for (int i = 7; i >= 0; i--)                {                    dTable.Rows.Remove(dTable.Rows[i]);                                    }                gridSource.DataSource = dTable;// gridSource ：（ DataGridView）            }            catch (Exception)            {                throw;            }        }