Skip to main content

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.

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


Terms & ConditionsCookie settings