@infrasoftbe/vnv-sdk
    Preparing search index...

    Class _infrasoftNodeTemplate

    La classe ExcelDocument étend la classe Workbook de la bibliothèque ExcelJS dans TypeScript.

    Hierarchy (View Summary)

    Index

    Constructors

    Properties

    calcProperties: CalculationProperties

    Workbook calculation Properties

    category: string
    company: string
    created: Date
    creator: string
    csv: Csv

    csv file format operations

    definedNames: DefinedNames
    description: string
    keywords: string
    lastModifiedBy: string
    lastPrinted: Date
    manager: string
    model: WorkbookModel
    modified: Date
    nextId: number
    nodeType: NodeType = null
    properties: WorkbookProperties
    subject: string
    title: string
    views: WorkbookView[]

    The Workbook views controls how many separate windows Excel will open when viewing the workbook.

    worksheets: Worksheet[]

    return a clone of worksheets in order

    xlsx: Xlsx

    xlsx file format operations

    Methods

    • Add Image to Workbook and return the id

      Parameters

      • img: Image

      Returns number

    • Add a new worksheet and return a reference to it

      Parameters

      • Optionalname: string
      • Optionaloptions: Partial<AddWorksheetOptions>

      Returns Worksheet

    • Iterate over all sheets.

      Note: workbook.worksheets.forEach will still work but this is better.

      Parameters

      • callback: (worksheet: Worksheet, id: number) => void

      Returns void

    • Parameters

      • id: number

      Returns Image

    • fetch sheet by name or id

      Parameters

      • OptionalindexOrName: string | number

      Returns Worksheet

    • Parameters

      • indexOrName: string | number

      Returns void

    • Parameters

      • worksheet: Worksheet

      Returns void