Interface ExcelExportOptionsIf

Options of an Excel export (ExcelService.downloadExcel, ExcelService.createExcelBlob).

Example

// an Arabic sheet: column A on the right, like the table
await new ExcelService().downloadExcel(matrix, "sales.xlsx", "", { rightToLeft: true });

Since

1.1.98

Hierarchy

  • ExcelExportOptionsIf

Properties

cellFormulas? rightToLeft?

Properties

Optional cellFormulas

cellFormulas?: boolean

TableApi.downloadExcel: cell formulas (TableOptionsIf.cellFormulas) become Excel formulas with their calculated values (otherwise: values). Only if the export is the sheet itself – no filter hides rows, no sorting, every data column visible; otherwise values and a warning. Since 1.1.99.

Optional rightToLeft

rightToLeft?: boolean

The worksheet runs from right to left (<sheetView rightToLeft="1">): column A on the right. TableApi.downloadExcel sets it for a right-to-left table (TableOptionsIf.direction).

Settings

Member Visibility

Theme

On This Page