将EXCEL数据导入到datagridview

最新推荐文章于 2024-01-30 20:37:11 发布

原创

最新推荐文章于 2024-01-30 20:37:11 发布 · 2.5k 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#C#

using System.Data;
using System.Data.OleDb;

string strPath;//文件路径名

private void  btnExcel_Click(object sender,EventArgs e)
{
    OpenFileDialog  ofd = new OpenFileDialog();
    ofd.Filter = "Excel文件|*.xlsx";
    if(ofd.ShowDialog() == DialogResult.OK)
    {
    	try
    	{
    	   strPath = ofd.FileName;
    	   String connStr = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source=" + strPath + ";Extended Properties = 'Excel 12.0 Xml;HDR = NO;IMEX=1;READONLY=TRUE'";
    	   OleDbConnection conn = new OleDbConnection(connStr);
    	   conn.Open();
    	   //返回EXCEL的架构，包括各个Sheet表的名称，类型，创建时间和修改时间等
    	   DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[]{null,null,null,"Table"});
    	   //包含EXCEL中表名的字符串数组
    	   string[] strTableNames = new string[dtSheetName.Rows.Count];
    	   for(int k = 0; k<dtSheetName.Rows.Count;k++)
    	   {
    	     strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
    	     comboBox1.Items.Add(str