API Reference
Class
DataTablesExcelExportBuilder
Fluent builder that generates a DataTables Buttons Excel customize(xlsx) function to tweak the workbook (sheet name, freeze header, column widths, number/date formats, auto-filter).
Inheritance
- Object
- DataTablesExcelExportBuilder
Methods
public DataTablesExcelExportBuilder AutoFilter(Boolean enable = true) #Returns:
DataTablesExcelExportBuilderEnable auto-filter on the header row.
Parameters
- enable System.Boolean = true
public DataTablesExcelExportBuilder ColumnWidth(Int32 columnIndex1Based, Double width) #Returns:
DataTablesExcelExportBuilderSet an explicit width for a 1-based column index.
Parameters
- columnIndex1Based System.Int32
- width System.Double
public DataTablesExcelExportBuilder FormatColumns(String excelFormatCode, params Int32[] columnIndexes1Based) #Returns:
DataTablesExcelExportBuilderApply an Excel number format code (e.g., "0", "0.00", "#,##0", "mm-dd-yy") to given columns.
Parameters
- excelFormatCode System.String
- columnIndexes1Based System.Int32[]
public DataTablesExcelExportBuilder FreezeHeaderRow(Boolean enable = true) #Returns:
DataTablesExcelExportBuilderFreezes the top header row.
Parameters
- enable System.Boolean = true
public DataTablesExcelExportBuilder SheetName(String name) #Returns:
DataTablesExcelExportBuilderSets the Excel sheet name.
Parameters
- name System.String