Get Free Trial

Export To Excel Header merged/centered only from A to J (10 columns). Missing column K (column 11)

Answered
Jackie Gao asked on November 15, 2021

See https://jsfiddle.net/0ch16um4/ -> Click EXPORT
Excel file header lines are merged/centered from A to J (10 columns). I need to include column K as part of the header (merge/center). Is it possible and how to do it? Thanks! 

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 17, 2021

Hello, Jackie,

Thank you for writing to us.
 
We want to describe to you the logic of adding a header in the export to Excel:

  • If the pivot contains less than 10 columns, the header will merge that exact amount of columns.
  • If the pivot contains more than 10 columns, the header will merge only the first 10 columns. That way, no matter how many columns are contained in the report, the text of the header would still be visible for a user.

Currently, it is not possible to make changes to this logic.

You are welcome to write to us in case further questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer