☝️Small business or a startup? See if you qualify for our special offer.
+
Get Free Trial
Get Free Trial

How to exclude all measures (values) when exporting?

posted on June 17th, 2025

Answered
Adrian Davey asked on June 17, 2025

Hi Support,

Is it possible to allow exporting (specifically to Excel), but exclude **all** measures (values), allowing only the dimensions to be exported?

e.g. In the screenshot, we would want to allow export to Excel, but the resulting Excel file should not contain any of the measures 'Billed Qty', 'Billed Val', 'Billed COS'.

The Excel file should only contain the list of 'PROD' dimensions.

Without specifically hard-coding each value to exclude (we would want all values, including any potential future values to be excluded from the export).

Kind regards,

1 answer

Public
Nadia Khodakivska Nadia Khodakivska ⋅ Flexmonster ⋅ June 19, 2025

Hello Adrian,

Thank you for contacting us.

Kindly note that the slice without values is considered invalid for Flexmonster. However, you can use export customization and follow these steps to customize the exported file:

  1. Use the destinationType: "plain" parameter of the exportTo() API call to retrieve the grid content as a Uint8Array returned in the callbackHandler.
  2. Use a third-party library (e.g., SheetJS) to process the resulting Uint8Array and apply the necessary changes, such as removing the values.

We hope it helps. You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer