How can I customize the column width on excel file when I export pivot table to excel (Angular 2+)

[Swagger]

With the pivot has only one column, the width is so big

[Swagger]

Please I need your help

[Mouli Eswararao]

Hi Swagger, 

 

Thanks for contacting Syncfusion support, 

 

Basically the pivot table component works in response. So, its columns are stretches based on the width of the component you have set. This is the default behavior. To avoid this kindly set allowAutoResizing property in gridSettings as “false”. We have prepared a sample for you please find it below. 

 

Sample: https://stackblitz.com/edit/ojufvr  

 

Please let us know if you have any other queries we are happy to assist you. 

 

Regards,
Mouli 

[Swagger]

Thanks you, really helpful

[Mouli Eswararao]

Hi Swagger, 

Thanks for the update. 

Regards,
Mouli