c# 读取excel数据

最新推荐文章于 2024-04-11 13:59:26 发布

平和的小六

最新推荐文章于 2024-04-11 13:59:26 发布

阅读量1.8k

点赞数 2

分类专栏：写代码文章标签： c# excel 开发语言 Powered by 金山文档

本文链接：https://blog.csdn.net/xiaoliu0515_0515/article/details/129498318

版权

写代码专栏收录该内容

4 篇文章 2 订阅

订阅专栏

使用WinForm测试

 //打标选择文件对话框


        public  string path = "";//文件路径
        private void button1_Click(object sender, EventArgs e)
        {
            System.Windows.Forms.OpenFileDialog fd = new OpenFileDialog();
            fd.Title = "选择文件";//选择框名称
            fd.Filter = "xls files (*.xls)|*.xls";//选择文件的类型Xls

            if (fd.ShowDialog() == DialogResult.OK)//文件路径
            {
                path = fd.FileName.Trim();
                path = path.Replace("\\","/");
            }
        }

导入Excel表

string strExcel = "select * from [信息表$]";

信息表对应excel的sheet名称

        public DataSet LoadDataExcel(string Path)
        {
            string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + Path + ";Extended Properties='Excel 12.0; HDR=Yes; IMEX=1'";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();

            string strExcel = "select * from [信息表$]";
            OleDbDataAdapter myDa = new OleDbDataAdapter(strExcel,conn);

            DataSet myDs = new DataSet();
            myDa.Fill(myDs);

            return myDs;
        }

WinForm按钮

  private void button2_Click(object sender, EventArgs e)
        {
            int i;
            i = 0;
            string temp=null;
            DataSet ds = LoadDataExcel(path);
            temp= ds.Tables[0].Rows[1].ItemArray[1].ToString();
            //for (i = 0; i < 4; i++)
            //{
            //    string a = ds.Tables[0].Rows[0].ItemArray[i].ToString();
            //    temp = a + "," + temp;
            //}

            MessageBox.Show(temp);
        }

Rows[1]、ItemArray[1]为第二行、第二列数据