How to set width of columns in the excel?

[Federico]

How to set width of columns in the excel with mvvm grid?

I have this function in the viewmodel:

$("#gridall").data("kendoGrid").bind("excelExport", function (e) {

            var sheet = e.workbook.sheets[0].columns;

        });

I'd like to set autoWidth property for all columns;

[Federico]

and, What should I do if I wanted to change the height of all the cells in a column?

[Preslav]

Hi Federico,

The desired functionality could be achieved by deleting the default width property and changing the autoWidth to true. For example, the modified code could look like:

excelExport: function(e) {
  var sheet = e.workbook.sheets[0];
  for (var i = 0; i < sheet.columns.length; i++) {
    delete sheet.columns[i].width;
    sheet.columns[i].autoWidth = true;
  }
}

For a runnable example, check this Dojo: http://dojo.telerik.com/OLIDO

Furthermore, I believe that it is a better approach to manually control the widths of the excel columns by explicitly setting the values by following the approach outlined in this forum:

• https://www.telerik.com/forums/exporting-grid-to-excel-with-width

Finally, changing the height of cells in a column is not possible. You could change the height of a row by using the sheets.rows.height configuration:

• https://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook#configuration-sheets.rows.height

I hope this helps.

Regards,
Preslav
Progress Telerik