OptionalprojectInstance: SourceWorkbook calculation Properties
Readonlycsvcsv file format operations
ReadonlydefinedReadonlynextThe Workbook views controls how many separate windows Excel will open when viewing the workbook.
return a clone of worksheets in order
Readonlyxlsxxlsx file format operations
StaticDatasetAdd Image to Workbook and return the id
Add a new worksheet and return a reference to it
Optionalname: stringOptionaloptions: Partial<AddWorksheetOptions>Iterate over all sheets.
Note: workbook.worksheets.forEach will still work but this is better.
fetch sheet by name or id
OptionalindexOrName: string | numberStaticcreateStaticisStaticSanetizeStatictoTransforms a project instance into an Excel report format
OptionalprojectInstance: ProxyProjectInstanceThe project instance to transform into Excel format
A report object containing the Excel representation of the project
This method creates an Excel report from a project instance with the following worksheets:
StatictoStatictoStaticValidate
La classe ExcelDocument étend la classe Workbook de la bibliothèque ExcelJS dans TypeScript.