Class PowerQueryFormulaFunction

PowerQueryFormulaFunction class

Represents the function of power query.

public class PowerQueryFormulaFunction : PowerQueryFormula

Properties

NameDescription
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