عرض الصيغ بدلاً من القيم في ورقة العمل

Contents
[ ]

يوفر Aspose.Cells خاصية Worksheet.ShowFormulas. اضبط هذا على صحيح لإعداد Microsoft Excel لعرض الصيغ.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
string filePath = dataDir+ "source.xlsx";
// Load the source workbook
Workbook workbook = new Workbook(filePath);
// Access the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Show formulas of the worksheet
worksheet.ShowFormulas = true;
// Save the workbook
workbook.Save(dataDir+ ".out.xlsx");