C# Form窗体读取excel表格

OpenFileDialog fileDialog = new OpenFileDialog();
                fileDialog.Filter = "Excel文件|*.xlsx;*.xls";
                fileDialog.ShowDialog();
                string filename = fileDialog.FileName;
                if (string.IsNullOrEmpty(filename)) return;
                BaseDirectory = System.IO.Path.GetDirectoryName(filename);
                using (FileStream stream = new FileStream(filename, FileMode.Open, FileAccess.Read, FileShare.Read))
                {
                    IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
                    //3. DataSet - The result of each spreadsheet will be created in the result.Tables
                    //DataSet result = excelReader.AsDataSet();
                    //4. DataSet - Create column names from first row
                    excelReader.IsFirstRowAsColumnNames = false;
                   //读取数据
                    DataSet ds = excelReader.AsDataSet();

 

posted @ 2017-10-23 16:27  之广  阅读(2181)  评论(0编辑  收藏  举报
我的博客——易之广