Workbook Constructor

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Workbook(host);

function Workbook( 
   host : Object
) : Workbook;

Parameters

host: - The host DOM element.

The following examples set options for the workbook.

Javascript

var spread = new GC.Spread.Sheets.Workbook($("#ss")[0],{sheetCount:3, font:"12pt Arial"});

Javascript

var spread = new GC.Spread.Sheets.Workbook($("#ss")[0],{sheetcount:3, newTabVisible:false});

Javascript

var spread = new GC.Spread.Sheets.Workbook($("#ss")[0], { sheetCount: 3, tabEditable: false });

Javascript

var spread = new GC.Spread.Sheets.Workbook($("#ss")[0],{sheetCount:3, tabStripVisible:false});

Javascript

var spread = new GC.Spread.Sheets.Workbook($("#ss")[0],{sheetCount:3, allowUserResize:false});

Javascript

var spread = new GC.Spread.Sheets.Workbook($("#ss")[0], { sheetCount: 3, allowUserZoom: false});

This table lists the Workbook options.

Name	Type	Description
sheetCount	number	The number of sheets, optional.
font	string	The tab strip font, optional.
allowUserDragDrop	boolean	Specifies whether to allow the user to drag and drop range data, optional.
allowUserDragFill	boolean	Specifies whether to allow the user to drag fill a range, optional.
allowUserZoom	boolean	Specifies whether to zoom the display by scrolling the mouse wheel while pressing the Ctrl key, optional.
allowUserResize	boolean	Specifies whether to allow the user to resize columns and rows, optional.
allowUndo	boolean	Specifies whether to allow the user to undo edits, optional.
allowSheetReorder	boolean	Specifies whether the user can reorder the sheets in the Spread component, optional.
allowCopyPasteExcelStyle	boolean	Specifies whether the user can copy styles from SpreadJS and then paste to Excel, or copy styles from Excel and then paste to SpreadJS, optional.
allowExtendPasteRange	boolean	Specifies whether to extend the paste range if the paste range is not enough for pasting, optional.
copyPasteHeaderOptions	GC.Spread.Sheets.CopyPasteHeaderOptions	Specifies which headers are included when data is copied to or pasted, optional.
defaultDragFillType	GC.Spread.Sheets.Fill.AutoFillType	The default fill type, optional.
showDragFillSmartTag	boolean	Specifies whether to display the drag fill dialog, optional.
showHorizontalScrollbar	boolean	Specifies whether to display the horizontal scroll bar, optional.
showVerticalScrollbar	boolean	Specifies whether to display the vertical scroll bar, optional.
scrollbarShowMax	boolean	Specifies whether the displayed scroll bars are based on the entire number of columns and rows in the sheet, optional.
scrollbarMaxAlign	boolean	Specifies whether the scroll bar aligns with the last row and column of the active sheet, optional.
tabStripVisible	boolean	Specifies whether to display the sheet tab strip, optional.
tabStripRatio	number	The width of the tab strip expressed as a percentage of the overall horizontal scroll bar width, optional.
tabEditable	boolean	Specifies whether to allow the user to edit the sheet tab strip, optional.
newTabVisible	boolean	Specifies whether the spreadsheet displays the special tab to let users insert new sheets, optional.
tabNavigationVisible	boolean	Specifies whether to display the sheet tab navigation, optional.
cutCopyIndicatorVisible	boolean	Specifies whether to display an indicator when copying or cutting the selected item, optional.
cutCopyIndicatorBorderColor	string	The border color for the indicator displayed when the user cuts or copies the selection, optional.
backColor	string	A color string used to represent the background color of the Spread component, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on, optional.
backgroundImage	string	The background image of the Spread component, optional.
backgroundImageLayout	GC.Spread.Sheets.ImageLayout	The background image layout for the Spread component, optional.
grayAreaBackColor	string	A color string used to represent the background color of the gray area , such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on, optional.
showResizeTip	GC.Spread.Sheets.ShowResizeTip	Specifies how to display the resize tip, optional.
showDragDropTip	boolean	Specifies whether to display the drag-drop tip, optional.
showDragFillTip	boolean	Specifies whether to display the drag-fill tip, optional.
showScrollTip	GC.Spread.Sheets.ShowScrollTip	Specifies how to display the scroll tip, optional.
scrollIgnoreHidden	boolean	Specifies whether the scroll bar ignores hidden rows or columns, optional.
highlightInvalidData	boolean	Specifies whether to highlight invalid data, optional.
useTouchLayout	boolean	Specifies whether to use touch layout to present the Spread component, optional.
hideSelection	boolean	Specifies whether to display the selection highlighting when the Spread component does not have focus, optional.
resizeZeroIndicator	GC.Spread.Sheets.ResizeZeroIndicator	The drawing policy when the row or column is resized to zero, optional.
allowUserEditFormula	boolean	Specifies whether the user can edit formulas in a cell in the spreadsheet, optional.
enableFormulaTextbox	boolean	Specifies whether to enable the formula text box in the spreadsheet, optional.
autoFitType	GC.Spread.Sheets.AutoFitType	Specifies whether content will be formatted to fit in cells or in cells and headers, optional.
referenceStyle	GC.Spread.Sheets.ReferenceStyle	The style for cell and range references in cell formulas on this sheet, optional.

Reference

Workbook type