EPPLUS 操作ExcelC#_epplus 选中多行-优快云博客

本文链接：https://blog.youkuaiyun.com/freshman_kang/article/details/72898863

本文介绍了一种使用C#从Excel文件中读取数据并将其转换为DataTable的方法。该过程包括打开Excel文件、获取工作表数量及每个工作表的数据范围，并将选定页的数据逐行逐列读入DataTable中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

FileInfo existingFile = new FileInfo(pfilePath);

            try
            {
                ExcelPackage package = new ExcelPackage(existingFile);
                int vSheetCount = package.Workbook.Worksheets.Count; //获取总Sheet页

ExcelWorksheet worksheet = package.Workbook.Worksheets[1];//选定指定页

int maxColumnNum = worksheet.Dimension.End.Column;//最大列
int minColumnNum = worksheet.Dimension.Start.Column;//最小列

int maxRowNum = worksheet.Dimension.End.Row;//最小行
int minRowNum = worksheet.Dimension.Start.Row;//最大行

                DataTable vTable = new DataTable();
                DataColumn vC;
                for (int j = 1; j <= maxColumnNum; j++)
                {
                    vC = new DataColumn("A_" + j, typeof(string));
                    vTable.Columns.Add(vC);
                }
                if (maxRowNum > 200)
                {
                    maxRowNum = 200;
                }
                for (int n = 1; n <= maxRowNum; n++)
                {
                    DataRow vRow = vTable.NewRow();
                    for (int m = 1; m <= maxColumnNum; m++)
                    {
                        vRow[m - 1] = worksheet.Cells[n, m].Value;
                    }
                    vTable.Rows.Add(vRow);
                }
                this.dataGridView1.DataSource = vTable;
            }
            catch (Exception vErr)
            {
                MessageBox.Show(vErr.Message);
            }
        }