Spreadsheet View
You can manipulate the sheets in a workbook by dynamically adding and removing them with JavaScript code.
To work with the worksheets of the SpreadJS workbook you need a reference to one of the worksheets. You can access any worksheet by its index, which is its position in the workbook, using the getSheet method of the Workbook object or using its name, which is the sheet's tab name, using the getSheetFromName workbook method. For example:
// Initialize a workbook
var workbook = GC.Spread.Sheets.findControl(document.getElementById('ss'));
// access a sheet by index
var sheet = workbook.getSheet(0);
// or by tab name
var sheet1 = workbook.getSheetFromName('Sheet1');
Use the Workbook getActiveSheet method to get an instance of the currently active worksheet.
// Get the active sheet
var sheet = workbook.getActiveSheet();
To change the active worksheet use the setActiveSheetIndex method and provide the index of the desired sheet. For example:
// Change the active Sheet
workbook.setActiveSheetIndex(1);
Once you have a reference to a worksheet, you can use it to customize it as illustrated by the demos in the Worksheet section.
Other useful methods to work with the workbook sheets:
- addSheet: add a named sheet at a specific position in the workbook.
var sheet = new GC.Spread.Sheets.Worksheet('New Sheet');
workbook.addSheet(0, sheet);
- getSheetCount: get the number of sheets in the workbook and use it to append a sheet to the workbook.
workbook.addSheet(workbook.getSheetCount());
- removeSheet and clearSheets: remove a sheet by index or clear all the workbook sheets.
workbook.removeSheet(0);
workbook.clearSheets();
- getActiveSheetIndex: get the index of the ActiveSheet.
// get the index of the active sheet
var activeSheetIndex = workbook.getActiveSheetIndex();
- changeSheetIndex: change activeSheet to another index.
// change the sheet index
workbook.changeSheetIndex("Sheet1", 2);
Feedback
Submit and view feedback for