Class PowerQueryFormulaFunction
Contents
[
Hide
]PowerQueryFormulaFunction class
Represents the function of power query.
public class PowerQueryFormulaFunction : PowerQueryFormula
Properties
Name | Description |
---|---|
Description { get; set; } | Gets and sets the description of the power query formula.(Inherited from PowerQueryFormula .) |
F { get; set; } | Gets and sets the definition of function. |
virtual FormulaDefinition { get; } | Gets the definition of the power query formula.(Inherited from PowerQueryFormula .) |
GroupName { get; } | Gets the name of group which contains this power query formula.(Inherited from PowerQueryFormula .) |
Name { get; set; } | Gets and sets the name of the power query formula.(Inherited from PowerQueryFormula .) |
PowerQueryFormulaItems { get; } | Gets all items of power query formula.(Inherited from PowerQueryFormula .) |
override Type { get; } | Gets the type of power query formula. |
Examples
using System;
using Aspose.Cells;
using Aspose.Cells.QueryTables;
namespace AsposeCellsExamples
{
public class QueryTablesClassPowerQueryFormulaFunctionDemo
{
public static void Run()
{
Workbook workbook = new Workbook("source.xlsx");
PowerQueryFormula formula = workbook.DataMashup.PowerQueryFormulas["from_timestamp"];
Console.WriteLine($"Name: {formula.Name}");
Console.WriteLine($"Type: {formula.Type}");
PowerQueryFormulaFunction function = (PowerQueryFormulaFunction)formula;
Console.WriteLine($"Signature: {function.F}");
workbook.Save("output.xlsx");
}
}
}
See Also
- class PowerQueryFormula
- namespace Aspose.Cells.QueryTables
- assembly Aspose.Cells