c# - 如何通过列名获取单元格值？

Question

我下面的代码工作正常，但如何按列名称指定？

for (int resultFiltered = 1; resultFiltered <= filteredRange.Areas.Count; areaId++)
{
  Range areaRange = filteredRange.Areas.Item(resultFiltered);
  string studentID = areaRange.Cells[1, 1].Value2; //How to specify column name?
}

Answer 1

您可以用列号代替列字母。

例子:

object rangeObject = activeWorksheet.Cells[3, "W"];

Range range = (Range)rangeObject;

object rangeValue = range.Value2;

string cellValue = rangeValue.ToString();

或者如果这有帮助，在我正在访问的 Excel 文件中，我将单元格“W5”命名为“overflow5”:

Range topExcel = activeWorksheet.get_Range("overflow5", Type.Missing);

topExcel.Select();

string cellValue = topExcel.Value2.ToString();