Excel has an AutoFilter feature which lets the end user quickly filter and sort data in the exported spreadsheet. To enable this feature on the header cells of the exported table, use the autoFilter option of the excelHtml5 button type. This example also shows the use of the sheetName option which allows the sheet in the exported workbook to be given a defined name.

The Excel export button saves to an XLSX file and the data can be customised before exporting the file using the customize method of the excelHtml5 button type. This example demonstrates how to manipulate the generated file by making the text in the third column (C) bold using the styling options that are built into the created spreadsheet. jQuery is used to select the required cells and then add a styling attribute.

The Excel export button saves to an XLSX file and the data can be customised before exporting the file using the customize method of the excelHtml5 button type. This example demonstrates how the created file can be customised by giving any cell in the Office column that has a value of 'New York' a blue background.

This example demonstrates how to manipulate the file using this method to add a styling attribute to a row in the XML used to create the XSLX file. The object passed into the customize method contains the XSLX's file structure and the worksheet can be accessed as shown. A jQuery selector is then used to select the cells in row 10 and add a border. More complex logic (such as conditionally adding borders based on cell content) could be used