将EXCEL数据导入到datagridview

LC—Dream

于 2019-04-27 23:09:16 发布

阅读量2.4k

点赞数

分类专栏： C# 文章标签： C#

本文链接：https://blog.csdn.net/LC_cat/article/details/89609459

版权

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.R