PowerQueryFormulaFunction.F
PowerQueryFormulaFunction.F property
Gets and sets the definition of function.
public string F { get; set; }
Examples
using System;
using Aspose.Cells;
using Aspose.Cells.QueryTables;
namespace AsposeCellsExamples
{
public class PowerQueryFormulaFunctionPropertyFDemo
{
public static void Run()
{
// Load a workbook that contains existing Power Query formulas
Workbook workbook = new Workbook("example.xlsx");
// Access Power Query formulas collection
PowerQueryFormulaCollection queryFormulas = workbook.DataMashup.PowerQueryFormulas;
// Retrieve an existing function formula by name
PowerQueryFormula formula = queryFormulas["from_timestamp"];
// Cast to PowerQueryFormulaFunction to access F property
if (formula is PowerQueryFormulaFunction function)
{
// Demonstrate getting the F property
Console.WriteLine("Original Function Definition: " + function.F);
// Demonstrate setting the F property
function.F = "(x as number) as datetimezone => #datetimezone(1970,1,1,0,0,0,0,0) + #duration(0,0,0,x)";
Console.WriteLine("Updated Function Definition: " + function.F);
}
// Save the workbook
workbook.Save("output.xlsx");
}
}
}
See Also
- class PowerQueryFormulaFunction
- namespace Aspose.Cells.QueryTables
- assembly Aspose.Cells