Excel Document

Add data from an Excel document to the report.

  1. Right-click at the Report or Chapter level and select Add > Items > Excel Document.


    Figure 1.
  2. Below are the properties associated with the Excel Document entity.


    Figure 2.
    1. Name: Edit the name property of the Excel document item.
      Note: Once you select an Excel file, the Excel item name is replaced with the selected file name.
    2. File Path: Select an Excel file using the file browser option.
    3. Sheet: Select a sheet from the Excel file to be inserted. All of the sheets in the selected Excel document are listed.
    4. Cell Range: Specify a cell range to be exported to the report.
      Note: By default, the entire cell range is added to the report.
      Cell Range Entries:
      • A1:C5: The top left corner of the table is A1 and the bottom right corner is C5.

    Advanced

  3. Table Caption: Provide a caption for the table entity. This caption is visible in the exported Word report.
  4. Location of Caption: Select the caption location from the list. These are standard locations as present in Microsoft Word. Table captions locations can be:


    Figure 3.
    1. Below Table, or
    2. Above Table