有没有一种方法可以使用OpenXml从列中获取最后填充的行单元格值

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

public string GetLastCellValue(string filePath, string sheetName, string columnName)
{
    string cellValue = null;

    using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filePath, false))
    {
        WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
        WorksheetPart worksheetPart = workbookPart.WorksheetParts.FirstOrDefault(wp => wp.Worksheet.Name == sheetName);

        if (worksheetPart != null)
        {
            SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();
            Row lastRow = sheetData.Elements<Row>().LastOrDefault();

            if (lastRow != null)
            {
                Cell targetCell = lastRow.Elements<Cell>().FirstOrDefault(c => GetColumnName(c.CellReference.Value) == columnName);

                if (targetCell != null)
                {
                    cellValue = GetCellValue(targetCell, workbookPart);
                }
            }
        }
    }

    return cellValue;
}

private string GetCellValue(Cell cell, WorkbookPart workbookPart)
{
    string cellValue = null;

    if (cell.DataType != null && cell.DataType.Value == CellValues.SharedString)
    {
        SharedStringTablePart sharedStringPart = workbookPart.GetPartsOfType<SharedStringTablePart>().FirstOrDefault();

        if (sharedStringPart != null)
        {
            SharedStringItem sharedStringItem = sharedStringPart.SharedStringTable.ElementAt(int.Parse(cell.CellValue.Text));
            cellValue = sharedStringItem.Text.Text;
        }
    }
    else
    {
        cellValue = cell.CellValue.Text;
    }

    return cellValue;
}

private string GetColumnName(string cellReference)
{
    string columnName = "";

    foreach (char c in cellReference)
    {
        if (Char.IsLetter(c))
        {
            columnName += c;
        }
        else
        {
            break;
        }
    }

    return columnName;
}