ComponentOne ASP.NET MVC Controls
IWorkbook Interface
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[]