Interface ExcelServiceIf

Writes an Excel file from a matrix of values. The default implementation is ExcelService; pass your own as last argument of the TableScope constructor to change how TableApi.downloadExcel exports.

Hierarchy

  • ExcelServiceIf

Implemented by

Properties

supportsFormulas?: boolean

True if the service understands cells of the form ExcelFormulaCellIf ({ formula, value }). Only then TableApi.downloadExcel with { cellFormulas: true } exports cell formulas as formulas (since 1.1.99).

supportsNumberFormats?: boolean

True if the service understands cells of the form ExcelFormattedValueIf ({ value, numberFormat }). Only then TableApi.downloadExcel exports percentages of „Show values as“ columns with the format 0.0%; otherwise a service gets plain numbers (since 1.1.95).

Methods

  • Creates the file from matrix (rows of values) and hands it to the browser as download.

    Parameters

    Returns void | Promise<void>