Table.InsertRows

语法

Table.InsertRows(table as table, offset as number, rows as list) as table

关于

返回一个表，此表包含插入到 table 中给定位置 offset 处的行 rows 的列表。 行中要插入的每列都与表的列类型匹配。

示例 1

将行插入表中的位置 1 处。

使用情况

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

输出

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

示例 2

将两行插入表中的位置 1 处。

使用情况

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

输出

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