🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Format Excel rows when using exportTo

Answered
Kim-Andre Kristiansen asked on January 28, 2021

Hi
When exporting to excel, if you have two or more rows they will appear in the same column with an indent to indicate the relationship between the data. This makes sense from a logic perspective. But we’ve had a request to show the rows as columns in excel. So that they are displayed similarly as they do in Flexmonster. Is this
possible?
Please see attached pictures for current, and desired display.

Best regards
Kim-Andre

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 28, 2021

Hello, Kim-Andre,
 
Thank you for reaching out to us.
 
We suggest checking out the classic form supported by Flexmonster.
It allocates a separate column for each expanded/drilled hierarchy, as the first screenshot demonstrates.
 
Please see the JSFiddle demonstrating the classic form. Try exporting the grid to Excel in order to make sure the structure is preserved.
 
The classic form can be configured in the Options Object:

options: {
  grid: {
    type: "classic"
  }
}

 
Please let us know if it helps.
Feel free to contact us in case other questions arise.
 
Kind regards,

Please login or Register to Submit Answer