Class PowerQueryFormulaItemCollection

PowerQueryFormulaItemCollection class

Represents all item of the power query formula.

public class PowerQueryFormulaItemCollection : CollectionBase<PowerQueryFormulaItem>

Properties

NameDescription
Capacity { get; set; }
Count { get; }
Item { get; }Gets PowerQueryFormulaItem by the index in the list. (2 indexers)
Item { get; set; }

Methods

NameDescription
BinarySearch(PowerQueryFormulaItem)
BinarySearch(PowerQueryFormulaItem, IComparer<PowerQueryFormulaItem>)
BinarySearch(int, int, PowerQueryFormulaItem, IComparer<PowerQueryFormulaItem>)
Clear()
Contains(PowerQueryFormulaItem)
CopyTo(PowerQueryFormulaItem[])
CopyTo(PowerQueryFormulaItem[], int)
CopyTo(int, PowerQueryFormulaItem[], int, int)
Exists(Predicate<PowerQueryFormulaItem>)
Find(Predicate<PowerQueryFormulaItem>)
FindAll(Predicate<PowerQueryFormulaItem>)
FindIndex(Predicate<PowerQueryFormulaItem>)
FindIndex(int, Predicate<PowerQueryFormulaItem>)
FindIndex(int, int, Predicate<PowerQueryFormulaItem>)
FindLast(Predicate<PowerQueryFormulaItem>)
FindLastIndex(Predicate<PowerQueryFormulaItem>)
FindLastIndex(int, Predicate<PowerQueryFormulaItem>)
FindLastIndex(int, int, Predicate<PowerQueryFormulaItem>)
GetEnumerator()
IndexOf(PowerQueryFormulaItem)
IndexOf(PowerQueryFormulaItem, int)
IndexOf(PowerQueryFormulaItem, int, int)
LastIndexOf(PowerQueryFormulaItem)
LastIndexOf(PowerQueryFormulaItem, int)
LastIndexOf(PowerQueryFormulaItem, int, int)
RemoveAt(int)

Examples

// Called: PowerQueryFormulaItemCollection PQFIcoll = PQF.PowerQueryFormulaItems;
public void QueryTables_Type_PowerQueryFormulaItemCollection()
{
    Workbook workbook = new Workbook(Constants.sourcePath + "example.xlsm");

    PowerQueryFormulaCollection PQFcoll = workbook.DataMashup.PowerQueryFormulas;//Exception here
    Assert.AreEqual(PQFcoll.Count, 2);

    PowerQueryFormula PQF = PQFcoll[1];
    Assert.AreEqual("Change Management", PQF.Name);
    PowerQueryFormulaItemCollection PQFIcoll = PQF.PowerQueryFormulaItems;
    Assert.AreEqual(3, PQFIcoll.Count);

    PowerQueryFormulaItem PQFI = PQFIcoll[0];
    Assert.AreEqual("Source", PQFI.Name);
    Assert.AreEqual(PQFI.Value, "SharePoint.Tables(\"https://cimconuso.sharepoint.com\", [ApiVersion = 15])");

    workbook.Save(Constants.destPath + "example.xlsm");

}

See Also