当前位置:   article > 正文

C# 打开指定的Excel_openfiledialog 打开excel

openfiledialog 打开excel

openFileDialog1 = new OpenFileDialog();
            openFileDialog1.Title = "打开excel文件";
            openFileDialog1.Filter = "(*.xlsx)|*.xlsx";
            openFileDialog1.InitialDirectory = @"C:\Users\Administrator\Desktop";
            openFileDialog1.RestoreDirectory = true;
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                //打开文件对话框选择的文件
                string excelpath = openFileDialog1.FileName;

                //Console.WriteLine(excelpath);
                //eo = new ExcelOperate();
                //readExcel(excelpath);

                Workbook wbk = app.Workbooks.Open(excelpath);
                Worksheet wsh = wbk.Worksheets[1];
                Console.WriteLine(Convert.ToString( wsh.Cells[1, 1].Text));

                wbk.Save();
                wbk.Close();
            }

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/花生_TL007/article/detail/698809
推荐阅读
相关标签
  

闽ICP备14008679号