Contents x
    Table.RemoveRows
    • 06 Aug 2024
    • 1 Minute to read
    • Dark
      Light
    Contents

    Table.RemoveRows

    • Updated on 06 Aug 2024
    • 1 Minute to read
    • Dark
      Light
    Article summary

    General

    The Table.RemoveRows can be used in the Post Processor property of a table Element to remove rows that contain cells of the given type.

    DataTopHeader = 0
    TotalsTopHeader = 1
    SubTotalsTopHeader = 2
    DataLeftHeader = 3
    TotalsLeftHeader = 4
    SubTotalsLeftHeader = 5
    Data = 6
    Total = 7
    SubTotal = 8
    Filler = 9

    Syntax

    The syntax of the Table.RemoveRows function is:

    Table.RemoveRows Function Syntax

    Table.RemoveRows(<cell type>)

    Examples

    All TotalsLeftHeader rows will be removed:

    Substring Function Example

    Table.RemoveRows(4)

    Was this article helpful?
    What's Next