Design Pivot Table in Excel

[Juan]

Hello,

I have set up a Pivot Table with XlsIO, and want to change your design as in Excel "Report Design" ==> "Show in tabular format".
By default, the design appears as Pivot Table "Show in compact form".

Is there any property to change the design?

Greetings.

[Sridhar Sukumar]

Hi Juan, 

 

Thank you for contacting Syncfusion support. 

 

Yes, you can change the pivot table’s report design by using RowLayout property. Please refer the following code snippet to change the pivot table report design as Show in tabular format. 

 

pivotTable.Options.RowLayout = PivotTableRowLayout.Tabular; 

 

 

We also have prepared a sample for the above behavior which can be downloaded from the following link. 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Pivot_Table_Design-1678827954.zip 

 

Regards, 

Sridhar S. 

[Juan]

Perfect!
Thank you very much!

[Sridhar Sukumar]

Hi Juan,  

 

Thank you for updating us. 

   

We are glad to know that the issue has been resolved at your side. Please let us know if you need any further assistance on this.  

   

Regards,  

Sridhar S.