Solved

export cube to excel without merged cells

  • 11 February 2020
  • 1 reply
  • 55 views

Userlevel 4
Badge +13

I noticed when exporting a cube to excel that the filters, column and data labels are printed to the first two rows of the file. This has the effect that the first 4 as well as the 6th column of the actual data (from row 4 onward) consist of so-called merged cells. Is it possible to export without those first 2 lines and end up with an export that consists of only regular single cells, similar to the output of a regular grid? Quite a few of our users struggle to integrate the current output in their analyses.

icon

Best answer by Jasper 18 February 2020, 16:27

View original

1 reply

Userlevel 7
Badge +11

Hi Roland,

We use the default export functionality of the integrated pivot grid component to export data to Excel, and it seems that it does support a “data-aware” export which only exports the data and column/row headers. Can you please submit an idea so that we can check if more developers are interested in having this option?

Reply