EPPLUS 操作ExcelC#

 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);             }         }