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

// Called: Assert.AreEqual("function (x as number) as datetimezone", ((PowerQueryFormulaFunction)powerQueryFormula).F);        // HtmlSaveOptions
public void QueryTables_Type_PowerQueryFormulaFunction()
{
    Workbook workbook = new Workbook(Constants.sourcePath + "example.xlsx");
    var powerQueryFormula = workbook.DataMashup.PowerQueryFormulas["from_timestamp"];
    Assert.AreEqual("from_timestamp", powerQueryFormula.Name);
    Assert.AreEqual(PowerQueryFormulaType.Function, powerQueryFormula.Type); // expected: Function, current value: Formula
    Assert.AreEqual("function (x as number) as datetimezone", ((PowerQueryFormulaFunction)powerQueryFormula).F);        // HtmlSaveOptions
    workbook.Save(Constants.destPath + "example.xlsx");
}

See Also