EPPlus将Excel的第一列读取到数组中

Question

将OpenFileDialog与EPPlus一起使用。我得到一个编译错误：

The name 'sheet' does not exist in the current context

现在，显而易见的问题是如何将所选的Excel文件与我的EPPPlus&2我该怎么做才能消除上面的错误？

using OfficeOpenXml;
using OfficeOpenXml.Drawing;
private void btn_ReadExcelToArray_Click(object sender, EventArgs e)
{
  fd.Filter = "Excel Files|*.xlsx";
  fd.InitialDirectory = @"C:";
  if (fd.ShowDialog() == DialogResult.OK)
  {          
    var columnimport = sheet.Cells["A2:A"];
    foreach (var cell in columnimport)
    {
        var column1CellValue = cell.GetValue<string>();
    }
  }
}

Answer 1

您非常接近。你所要做的就是基于流创建包（或者你可以使用fileinfo重载——无论哪种方式）。像这样：

var fd = new OpenFileDialog();
fd.Filter = "Excel Files|*.xlsx";
fd.InitialDirectory = @"C:Temp";
if (fd.ShowDialog() == DialogResult.OK)
{
    using (var package = new ExcelPackage(fd.OpenFile()))
    {
        var sheet = package.Workbook.Worksheets.First();
        var columnimport = sheet.Cells["A2:A"];
        foreach (var cell in columnimport)
        {
            var column1CellValue = cell.GetValue<string>();
        }
    }
}