1. GroupDocs Documentation
    2. /
    3. GroupDocs.Assembly Product Family
    4. /
    5. GroupDocs.Assembly for Java
    6. /
    7. Developer Guide
    8. /
    9. Advanced Usage
    10. /
    11. Working with Table Reports - Highlighted Rows
    12. /
    13. In-Table List with Highlighted Rows in Spreadsheet Document

    In-Table List with Highlighted Rows in Spreadsheet Document

    Note
    In this article, we will use GroupDocs.Assembly to generate In-TableList with Highlighted Rows report in Spreadsheet Document format.
    Note
    The code uses some of the objects defined in The Business Layer.

    In-Table List with Highlighted Rows in Microsoft Excel Document

    Creating a In-Table List with Highlighted Rows

    Practising the following steps you can create In-Table List with Highlighted Rows Template in MS Excel 2013.

    1. Add a new Workbook.
    2. Select the range of cells that you want to include in the table.
    3. On the Insert tab, in the Tables group, click Table.
    4. Insert a 2x4 table.
    5. Click the cell you want to highlight.
    6. Click “Cell Styles” in Styles group.
    7. Save the template.

    Reporting Requirement

    As a report developer, you are required to represent the following key requirements:

    • Report must show all the client names with price.
    • Show single client and his single contract price in a single row.
    • It must highlight the record with contract price more than or equal to 1000000.
    • It must show sum of the contract prices.
    • It must represent all the information in tabular form.
    • Report must be generated in the Spreadsheet Document.

    Adding Syntax to be evaluated by GroupDocs.Assembly Engine

     

    Client

    Contract Price

    <<foreach [in getContracts()]>><<if [getPrice() >= 1000000]>><<[getClient().getName()]>>

    <<[getPrice()]>>

    <<else>><<[getClient().getName()]>>

    <<[getPrice()]>><</if>><</foreach>>

    Total:

    <<[getContracts().sum(

      c => c.getPrice())]>>

     

     

    ### Download In-Table List with Highlighted Rows Template

    Please download the sample In-Table List with Highlighted Rows document we created in this article:

    Generating The Report

    ODS Template and Report in Apache OpenOffice

    In order to check compatibility of ODS between Microsoft Office 2010 and Apache OpenOffice 4.1.2, we performed below tests:

    • We opened the ODS template created through Microsoft Office 2010 in Apache OpenOffice 4.1.2. The template opened successfully in Apache OpenOffice without any issues or formatting losses.
    • We opened the ODS report generated through GroupDocs.Assembly in Apache OpenOffice 4.1.2. The report opened successfully in Apache OpenOffice without any issues or formatting losses.
    © Groupdocs 2001-2024. All Rights Reserved.