Table.RemoveRows

语法

Table.RemoveRows(table as table, offset as number, optional count as nullable number) as table

关于

从指定的 offset 开始，从 table 的开头删除 count 行。 如果未提供 count 参数，则使用默认计数 1。

示例 1

从表中删除第一行。

使用情况

Table.RemoveRows(    Table.FromRecords({         [CustomerID = 1, Name = "Bob", Phone = "123-4567"],        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]     }),    0)

输出

Table.FromRecords({     [CustomerID = 2, Name = "Jim", Phone = "987-6543"],    [CustomerID = 3, Name = "Paul", Phone = "543-7890"],    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"] })

示例 2

删除表中位置 1 的行。

使用情况

Table.RemoveRows(    Table.FromRecords({         [CustomerID = 1, Name = "Bob", Phone = "123-4567"],        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]     }),    1)

输出

Table.FromRecords({     [CustomerID = 1, Name = "Bob", Phone = "123-4567"],    [CustomerID = 3, Name = "Paul", Phone = "543-7890"],    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"] })

示例 3

从位置 1 开始，删除表中的两行。

使用情况

Table.RemoveRows(    Table.FromRecords({         [CustomerID = 1, Name = "Bob", Phone = "123-4567"],        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]     }),    1,    2)

输出

Table.FromRecords({     [CustomerID = 1, Name = "Bob", Phone = "123-4567"],    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"] })