Export huge tables

    By default, biExport only adds into the export document what is visible on the screen. This means that not all rows of a Table Widget may be shown in the export.

    Activating the entire resultset

    You can easily change this by adding the Table Widget in the Retrieve add. Data parameter in the General Section of the biExport Widget:

    This activates the extraction of the result set for this specific Table Widget, and in consequence biExport can show also the hidden rows and columns.

    The extraction is not automatically activated for performance reasons - in order to limit the amount of data transferred to the biExport service.

    Beautifying the result

    Huge tables are a problem especially in PowerPoint, where they will either be scaled down to fit to the slide, or flow over the boundaries of the slide.

    Also in Word (tables with a lot of columns) and Excel (distribute different groups of data on separate sheets) there might be the requirement to enhance the export of the table.

    How the Table Widget shall be exported can be controlled by placeholder suffixes in the Export document.

    Here are some examples of how you can change the appearance of tables with a placeholder suffix:

    Placeholder
    Description
    Placeholder
    %Table_1%:IMAGE[20X50]
    Description
    Split the table after 20 columns and 50 rows as an image that keeps the formatting of the Table Widget
    Placeholder
    %Table_1%:TEXT[10X20]
    Description
    Split an editable export of the table after 10 columns and 20 rows in PowerPoint
    Placeholder
    %Table_1%:TEXT[10X9999]
    Description
    Split an editable export of the table after 10 columns in Word
    Placeholder
    %Table_1%:TEXT[0COUNTRY]
    Description
    Split an editable export of the table after a group change on 0COUNTRY in Excel
    Placeholder
    %Table_1%:TEXT[15X30]{font-size:6px}
    Description
    Create an editable export of the table with a smaller font size, allowing to show more rows and columns at once
    Placeholder
    %Table_1%:VALUE{formatAsTable:myDefinition}
    Description
    Export the raw data of the table and format as with an Office Table Style
    Thilo Knötzele
    Author: Thilo Knötzele
    Creation date: 19.11.2022
    Category: Implementation
    back to overview