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

posted on November 15th, 2021

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 ⋅ 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

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

1 answer

Please login or Register to Submit Answer