Represents an Excel workbook.
constructor(): Workbook
Initializes a new instance of the Workbook class.
Gets or sets the name of application that generated the file that appears in the file properties.
Gets or sets the name of company that generated the file that appears in the file properties.
Gets or sets the reserved content from xlsx file that flexgrid or flexsheet doesn't support yet.
fromXlsxFormat(xlsxFormat: string): string[]
Converts the xlsx multi-section format string to an array of corresponding wijmo formats.
The Excel format string, that may contain multiple format sections separated by a semicolon.
load(base64: string): void
Loads from base-64 string or data url. This method works with JSZip 2.5.
For example:
// This sample opens an xlsx file chosen from Open File
// dialog and creates a workbook instance to load the file.
// HTML
<input type="file"
id="importFile"
accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
/>
// JavaScript
var workbook, // receives imported IWorkbook
importFile = document.getElementById('importFile');
importFile.addEventListener('change', function () {
loadWorkbook();
});
function loadWorkbook() {
var reader,
workbook,
file = importFile.files[0];
if (file) {
reader = new FileReader();
reader.onload = function (e) {
workbook = new wijmo.xlsx.Workbook(),
workbook.load(reader.result);
};
reader.readAsDataURL(file);
}
}
The base-64 string that contains the xlsx file content.
loadAsync(base64: string, onLoaded?: (workbook: Workbook), onError?: (reason?: any)): void
Loads from base-64 string or data url asynchronously. This method works with JSZip 3.0.
base64 string that contains the xlsx file content.
This callback provides an approach to get an instance of the loaded workbook. Since this method is an asynchronous method, user is not able to get instance of the loaded workbook immediately. User has to get the instance through this callback. This has a single parameter, instance of the loaded workbook. It will be passed to user.
This callback catches error information when loading. This has a single parameter, the failure reason. Return value is be passed to user, if he wants to catch the load failure reason.
For example:
workbook.loadAsync(base64, function (workbook) {
// User can access the loaded workbook instance in this callback.
var app = worksheet.application ;
...
}, function (reason) {
// User can catch the failure reason in this callback.
console.log('The reason of load failure is ' + reason);
});
save(fileName?: string): string
Saves the book to a file and returns a base-64 string representation of the book. This method works with JSZip 2.5.
For example, this sample creates an xlsx file with a single cell:
function exportXlsx(fileName) {
var book = new wijmo.xlsx.Workbook(),
sheet = new wijmo.xlsx.WorkSheet(),
bookRow = new wijmo.xlsx.WorkbookRow(),
bookCell = new wijmo.xlsx.WorkbookCell();
bookCell.value = 'Hello, Excel!';
bookRow.cells.push(bookCell);
sheet.rows.push(bookRow);
book.sheets.push(sheet);
book.save(fileName);
}
The file name is optional. If not provided, the method still returns a base-64 string representing the book. This string can be used for further processing on the client or on the server.
Name of the xlsx file to save.
saveAsync(fileName?: string, onSaved?: (base64?: string), onError?: (reason?: any)): void
Saves the book to a file asynchronously. This method works with JSZip 3.0.
Name of the xlsx file to save.
This callback provides an approach to get the base-64 string that represents the content of the saved workbook. Since this method is an asynchronous method, user does not get the base-64 string immediately. User has to get the base-64 string via this callback. This has a single parameter, the base-64 string of the saved workbook. It will be passed to user.
This callback catches error information when saving. This has a single parameter, the failure reason. Return value will be passed to user, if he wants to catch the save failure reason.
For example:
workbook.saveAsync('', function (base64){
// User can access the base64 string in this callback.
document.getElementByID('export').href = 'data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;' + 'base64,' + base64;
}, function (reason){
// User can catch the failure reason in this callback.
console.log('The reason of save failure is ' + reason);
});
tableAddress(xlsxIndex: string): ITableAddress
Convert Excel's alphanumeric cell, row or column index to the zero-based row/column indices pair.
The alphanumeric Excel index that may include alphabetic A-based column index and/or numeric 1-based row index, like "D15", "D" or "15". The alphabetic column index can be in lower or upper case.
toXlsxDateFormat(format: string): string
Converts the wijmo date format to Excel format.
The wijmo date format.
toXlsxNumberFormat(format: string): string
Converts the wijmo number format to xlsx format.
The wijmo number format.
xlsxAddress(row: number, col: number, absolute?: boolean, absoluteCol?: boolean, isWholeRow?: boolean): string
Converts zero-based cell, row or column index to Excel alphanumeric representation.
The zero-based row index or a null value if only column index is to be converted.
The zero-based column index or a null value if only row index is to be converted.
True value indicates that absolute indices is to be returned for both, row and column (like $D$7). The absoluteCol parameter allows to redefine this value for the column index.
True value indicates that column index is absolute.
Indicates whether the Cell reference is whole row, whole column or specific cell range. If isWholeRow is true means the cell reference is whole row. If isWholeRow is false means the cell reference is whole column. If isWholeRow is null means the cell reference is specific cell range.