问从工作表中查找链接公式值，并用实际单元格值替换。

EN

public void Remove_CellReferences(string filepath)
{
    using (SpreadsheetDocument spreadsheet = SpreadsheetDocument.Open(filepath, true))
    {
        // Delete all cell references in worksheet
        List<WorksheetPart> worksheetparts = spreadsheet.WorkbookPart.WorksheetParts.ToList();
        foreach (WorksheetPart part in worksheetparts)
        {
            Worksheet worksheet = part.Worksheet;
            var rows = worksheet.GetFirstChild<SheetData>().Elements<Row>(); // Find all rows
            foreach (var row in rows)
            {
                var cells = row.Elements<Cell>();
                foreach (Cell cell in cells)
                {
                    if (cell.CellFormula != null)
                    {
                        string formula = cell.CellFormula.InnerText;
                        if (formula.Length > 0)
                        {
                            string hit = formula.Substring(0, 1); // Transfer first 1 characters to string
                            if (hit == "[")
                            {
                                CellValue cellvalue = cell.CellValue; // Save current cell value
                                cell.CellFormula = null; // Remove RTD formula
                                                         // If cellvalue does not have a real value
                                if (cellvalue.Text == "#N/A")
                                {
                                    cell.DataType = CellValues.String;
                                    cell.CellValue = new CellValue("Invalid data removed");
                                }
                                else
                                {
                                    cell.CellValue = cellvalue; // Insert saved cell value
                                }
                            }
                        }
                    }
                }
            }
        }
        // Delete all external link references
        List<ExternalWorkbookPart> extwbParts = spreadsheet.WorkbookPart.ExternalWorkbookParts.ToList();
        if (extwbParts.Count > 0)
        {
            foreach (ExternalWorkbookPart extpart in extwbParts)
            {
                var elements = extpart.ExternalLink.ChildElements.ToList();
                foreach (var element in elements)
                {
                    if (element.LocalName == "externalBook")
                    {
                        spreadsheet.WorkbookPart.DeletePart(extpart);
                    }
                }
            }
        }
        // Delete calculation chain
        CalculationChainPart calc = spreadsheet.WorkbookPart.CalculationChainPart;
        spreadsheet.WorkbookPart.DeletePart(calc);
    }
}