Configure Custom Headers for Exported XLSX Files

You can customize the headers used in the XLSX exports of insights and dashboards in each of your workspaces.

You can add up to 5 headers (rows) to your XLSX files, each displayed on a separate row. By default, the XLSX file has no headers predefined.

You can specify XLSX headers through:

  • Platform Settings
  • GoodData API

Adding Headers Through Platform Settings

Steps:

  1. Access Platform Settings. For details, see Configure Various Features via Platform Settings.

  2. In the Config section at the bottom of the page in the Key field, type exporter.ExcelExport.CustomHeader.N where N<=5 and specifies the number of the row.

  3. For Value, type what you want to display in the header.  You can use text or macros (see Macro References below).

  4. Click Create config.

  5. Log in to the GoodData Portal and verify that the headers export correctly.

Adding Headers Through GoodData API

To add XLSX headers through GoodData API, see API Reference.

Macro References

You can apply the following macros for XLSX headers. You can use them separately or insert them inline with other text references.

Report Related Macros

MacroDescription

%PROJECT_ID

Internal workspace identifier

%PROJECT_NAME

Display name of the workspace

%REPORT_NAME

Display name of the source insight

%REPORT_DESCRIPTION

Insight description value

Date and Time Macros

All date and time values indicate when the report was generated. Values in parentheses are examples for March 07, 2018 at 2:04:05 p.m.

MacroDescription

%YYYY

Year (2018)

%YY

Year (18)

%MM

Month with a leading zero (03)

%M

Month (3)

%DD

Day of month with leading zero (07)

%D

Day of month (7)

%HH

Hour with leading zero in 24-hour format (14)

%H

Hour in 24-hour format (14)

%hh

Hour with leading zero in 12-hour format (02)

%h

Hour in 12-hour format (2)

%am

a.m. or p.m. (p.m.)

%mm

Minutes (04)

%ss

Seconds (05)

%z

General time zone (PST)

%ZRFC 822 time zone (-0800)