New to Kendo UI for jQuery? Start a free 30-day trial

Sheets.columns

configuration

The column configuration.

sheets.columns

Array

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          columns: [
              { width: 100 },
              { width: 200, autoWidth: false },
              { width: 150 }
          ],
          rows: [
              { cells: [ 
                  { value: "ID" }, 
                  { value: "Product Name" }, 
                  { value: "Price" } 
              ] },
              { cells: [ 
                  { value: 1 }, 
                  { value: "Laptop Computer" }, 
                  { value: 999.99 } 
              ] }
          ]
      }
  ]
});

workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "columns-example.xlsx"
  });
});
</script>

sheets.columns.autoWidth

Boolean

If set to true, the column will stretch to fit the contents of all cells.

Default: false

  <script>
  var workbook = new kendo.ooxml.Workbook({
    sheets: [
        {
            columns: [ { autoWidth: true } ],
            rows: [
              { cells: [ { value: "short" } ] },
              { cells: [ { value: "longer text value" } ] }
            ]
        }
    ]
  });
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
  </script>

sheets.columns.index

Number

The zero-based index of the column in the sheet. Defaults to the index of the object in the array.

  <script>
  var workbook = new kendo.ooxml.Workbook({
    sheets: [{
        columns: [{
            width: 100,
            index: 1
        }]
    }]
  });
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
  </script>

sheets.columns.width

Number

The width (in pixels) of the column.

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          columns: [ { width: 100 }, { width: 200 } ],
          rows: [
            {
              cells: [
                { value: "this column is 100px" }, { value: "this column is 200px" }
              ]
            }
          ]
      }
  ]
});
workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "Test.xlsx"
  });
});
</script>