ASP.NET MVC Controls | ComponentOne
In This Topic
    IWorkbook Interface
    In This Topic
    File
    wijmo.xlsx.js
    Module
    wijmo.xlsx

    Represents an Excel Workbook. This interface is the root of the Excel Workbook Object Model (WOM) which provides a way to define properties and data stored in xlsx file.

    To create an xlsx file, create a Workbook object and populate them with WorkSheet, WorkbookColumn, WorkbookRow, and WorkbookCell objects.

    To save xlsx files, use the save method which can save the book to a file or return it as a base-64 string.

    To load existing xlsx files, use the load method which will populate the book.

    Properties

    Properties

    activeWorksheet

    Index of the active sheet in the xlsx file.

    Type
    number

    application

    Name of the application that generated the file that appears in the file properties.

    Type
    string

    colorThemes

    The color of the workbook themes.

    Type
    string[]

    company

    Name of the company that generated the file that appears in the file properties.

    Type
    string

    created

    Creation time of the xlsx file.

    Type
    Date

    creator

    Creator of the xlsx file.

    Type
    string

    definedNames

    The array of the defined name items.

    Type
    IDefinedName[]

    lastModifiedBy

    Last modifier of the xlsx file.

    Type
    string

    modified

    Last modified time of the xlsx file.

    Type
    Date

    reservedContent

    The reserved content for the workbook.

    Type
    any

    sheets

    Defines an array of Excel Workbook sheets.

    Type
    IWorkSheet[]

    styles

    Styles table of the workbook.

    Type
    IWorkbookStyle[]