# Add summary row

Command Description

Export to Excel allows you to save your report data in a widely used spreadsheet format. You can open the exported file in Microsoft Excel for further analysis, formatting, or sharing.

How to export to excel

  1. In the Advanced Report – Define Sheets dialog, click on button.

  2. Set Excel sheet settings in the Excel Sheet Settings dialog.

  • Auto fit column width: Automatically adjusts the width of all columns to fit their content.
  • Remove first column: Excludes the first column from the exported Excel sheet.
  • Hide title: Hides the report title in the Excel export.
  • Hide subtitle: Hides the report subtitle in the Excel export.
  • Merge title and subtitle cells: Combines the title and subtitle cells into one merged cell.
  • Keep only summary rows: Exports only summary rows while excluding detailed data.
  • Separate summary group name: Places the group name in a separate cell in summary rows.
  • Separate summary fields: Places each summary field in its own separate cell.
  • Hide property name in group decription: Excludes property names from the group description text.
  • Export grouped columns: Includes grouped columns in the exported Excel sheet.
  • Cell type: Select the cell type (title, subtitle, content, summary row) to apply formatting such as font, size, bold italic, or underline.
  • Font color: Sets the font color of the exported Excel text.
  • Fill color: Sets the background color of cells in the Excel export.
  • Text font and size: Specifies the font family and size for text in Excel.
  • Horizontal alignment: Aligns text horizontally (left, center, or right).
  • Vertical alignment: Aligns text vertically (top, center, or bottom).

  1. Click OK to confirm the settings.

  2. Click button to export the report to Excel.

  3. In Save as dialog, define the file name and the desired location where you want to save the file.

  4. With button, you can save the report and reuse it in future projects.

  5. By clicking the button, you can return at any time to the Advanced Report – Define Sheets dialog, where you can add or remove datasets.

  6. With the button you can refresh the report in case the data was changed in the drawing.

  7. Click to close the dialog.

←