Class PowerQueryFormulaCollection

PowerQueryFormulaCollection class

Represents all power query formulas in the mashup data.

public class PowerQueryFormulaCollection : CollectionBase<PowerQueryFormula>

Properties

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

Methods

NameDescription
BinarySearch(PowerQueryFormula)
BinarySearch(PowerQueryFormula, IComparer<PowerQueryFormula>)
BinarySearch(int, int, PowerQueryFormula, IComparer<PowerQueryFormula>)
Clear()
Contains(PowerQueryFormula)
CopyTo(PowerQueryFormula[])
CopyTo(PowerQueryFormula[], int)
CopyTo(int, PowerQueryFormula[], int, int)
Exists(Predicate<PowerQueryFormula>)
Find(Predicate<PowerQueryFormula>)
FindAll(Predicate<PowerQueryFormula>)
FindIndex(Predicate<PowerQueryFormula>)
FindIndex(int, Predicate<PowerQueryFormula>)
FindIndex(int, int, Predicate<PowerQueryFormula>)
FindLast(Predicate<PowerQueryFormula>)
FindLastIndex(Predicate<PowerQueryFormula>)
FindLastIndex(int, Predicate<PowerQueryFormula>)
FindLastIndex(int, int, Predicate<PowerQueryFormula>)
GetEnumerator()
IndexOf(PowerQueryFormula)
IndexOf(PowerQueryFormula, int)
IndexOf(PowerQueryFormula, int, int)
LastIndexOf(PowerQueryFormula)
LastIndexOf(PowerQueryFormula, int)
LastIndexOf(PowerQueryFormula, int, int)
RemoveAt(int)
RemoveBy(string)Remove power query formula by name.

Examples

using Aspose.Cells;
using Aspose.Cells.QueryTables;
using System;

namespace AsposeCellsExamples
{
    public class PowerQueryFormulaDemo
    {
        public static void RunDemo()
        {
            // Create a new workbook
            Workbook workbook = new Workbook("PowerQueryFormulaDemo_original.xlsx");

            // Create a DataMashup object
            DataMashup dataMashup = workbook.DataMashup;

            // Access PowerQueryFormulas collection
            PowerQueryFormulaCollection powerQueryFormulas = dataMashup.PowerQueryFormulas;

            // Display the count of Power Query formulas
            Console.WriteLine($"Number of Power Query Formulas: {powerQueryFormulas.Count}");

            // Example of accessing a specific Power Query formula (if any exist)
            if (powerQueryFormulas.Count > 0)
            {
                PowerQueryFormula firstFormula = powerQueryFormulas[0];
                Console.WriteLine($"First Power Query Formula: {firstFormula}");
            }

            // Save the workbook
            workbook.Save("PowerQueryFormulaDemo.xlsx");
        }
    }
}

See Also