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 Image Reports - Common List
    12. /
    13. Common List Image in Spreadsheet Document

    Common List Image in Spreadsheet Document

    Note
    In this article, we will use GroupDocs.Assembly to generate a Common List Image report in Spreadsheet Document format.
    Note
    The code uses some of the objects defined in The Business Layer.

    Common List in Microsoft Excel Document

    Creating a Common List

    Please follow below steps to create Common List Image in MS Excel 2013:

    1. Insert the desired shape to display image in it.
    2. Go to Insert Tab and select shape by clicking on Shape Icon.
    3. Save your Document.

    Reporting Requirement

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

    • Report must show multiple managers’ picture and name.
    • Report must be generated in the Spreadsheet Document.

    Adding Syntax to be evaluated by GroupDocs.Assembly Engine

    «foreach [in getManagers()]»

    <<image [getPhoto()]>>
    <<[getName()]>> <>

    Download Template

    Please download the sample Common List 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.