C#获取Excel文件路径

最新推荐文章于 2023-06-13 15:15:22 发布

非鱼贩客

最新推荐文章于 2023-06-13 15:15:22 发布

阅读量2k

点赞数 1

本文链接：https://blog.csdn.net/ly2497935393/article/details/106557674

版权

//打开文件对话框选择文件
            OpenFileDialog file = new OpenFileDialog();
            file.Filter = "Excel(*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
            file.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
            file.Multiselect = false;
            if (file.ShowDialog() == DialogResult.OK)
            {
                this.txtPath.Text= file.FileName;
               
                //string filePath = file.FileName;
                //string fileSuffix = System.IO.Path.GetExtension(filePath);
                //DataTable dt;
                //if (fileSuffix == ".xls")
                //{
                //    dt = this.ExcelDataTable(file.FileName, 2);
                //}
                //else
                //{
                //    dt = this.ExcelDataTable(file.FileName, 1);
                //}
            }