Using FormulaText function in Aspose.Cells
Contents
[
Hide
]
FormulaText is an Excel 2013 and later function. It is not supported by previous versions like Excel 2010 or 2007 etc. As its name suggests, it prints the text of the formula which is present in a given cell. This article will show you how to make use of this function using Aspose.Cells.
The following sample code shows the usage of FormulaText with Aspose.Cells. The code first writes a formula in cell A1 and then prints the text of the formula using FormulaText in cell A2.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// Create a workbook object | |
Workbook workbook = new Workbook(); | |
// Access first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Put some formula in cell A1 | |
Cell cellA1 = worksheet.Cells["A1"]; | |
cellA1.Formula = "=Sum(B1:B10)"; | |
// Get the text of the formula in cell A2 using FORMULATEXT function | |
Cell cellA2 = worksheet.Cells["A2"]; | |
cellA2.Formula = "=FormulaText(A1)"; | |
// Calculate the workbook | |
workbook.CalculateFormula(); | |
// Print the results of A2, It will now print the text of the formula inside cell A1 | |
Console.WriteLine(cellA2.StringValue); |
Console Output
Here is the console output of the above sample code.
=SUM(B1:B10)