AutoFit Column Width when exporting to Excel

niksdope

Hey,

Is it possible to set columns to AutoFit Width when exporting to Excel?
I'm running into a problem with currency column data displaying as ###### because the column width is too small. I can set the column width manually but it'd be great to be able to make it fit to the max data size automatically.

I found a previous discussion about this (https://datatables.net/forums/discussion/23147/auto-fit-for-excel-columns-while-exporting-from-data-table-using-tabletools) but there was no answer and the thread was closed.

Thanks,
Niks

colin

Hi @niksdope ,

The options for the Excel customisations are on this page here. It says it attempts to auto-size automatically - if that's not happening, I suspect you'll have to dive into the links at the end of the "Customisation" section.

Cheers,

Colin

niksdope

A change to _excelColWidth in a newer version of buttons.html5.js fixed this.