constructor(owner?: FlexSheet, grid?: FlexGrid, sheetName?: string, rows?: number, cols?: number): Sheet
Initializes a new instance of the Sheet class.
The owner @see: FlexSheet control.
The associated FlexGrid control used to store the sheet data. If not specified then the new FlexGrid control will be created.
The name of the sheet within the FlexSheet control.
The row count for the sheet.
The column count for the sheet.
Gets or sets the filter setting for this sheet.
Gets the associated FlexGrid control used to store the sheet data.
This event is triggered after the component has been initialized by Angular, that is all bound properties have been assigned and child components (if any) have been initialized.
Indicates whether the component has been initialized by Angular. Changes its value from false to true right before triggering the initialized event.
Gets or sets the array or ICollectionView for the FlexGrid instance of the sheet.
Angular (EventEmitter) version of the Wijmo nameChanged event for programmatic access. Use this event name if you want to subscribe to the Angular version of the event in code. In template bindings use the conventional nameChanged Wijmo event name.
Gets the collection of the Table objects on this Sheet. It allows to insert/remove Table on this Sheet via the tables collection.
Gets or sets a name of a property that this component is assigned to. Default value is 'sheets'.
addTableFromArray(row: number, column: number, array: any[], properties?: string[], tableName?: string, tableStyle?: TableStyle, options?: ITableOptions, shift?: boolean): Table
Add table from an object array.
The row position of the table.
The column position of the table.
The object array load to the table.
It allows to retrieve only a subset of columns from the object of the array. If it is omitted, the table will load all the keys of the object of the array.
The name of the table.
The table style is applied to the table.
The options ITableOptions of the table.
Indicates whether cells beneath the table should be shifted or not. If not specified cells beneath will be shifted.
created(): void
If you create a custom component inherited from a Wijmo component, you can override this method and perform necessary initializations that you usually do in a class constructor. This method is called in the last line of a Wijmo component constructor and allows you to not declare your custom component's constructor at all, thus preventing you from a necessity to maintain constructor parameters and keep them in synch with Wijmo component's constructor parameters.
findTable(rowIndex: number, columnIndex: number): Table
Finds the table via the cell location.
getCellStyle(rowIndex: number, columnIndex: number): ICellStyle
Gets the style of specified cell.
the row index of the specified cell.
the column index of the specified cell.
onNameChanged(e: PropertyChangedEventArgs): void
Raises the nameChanged event.
onVisibleChanged(e: EventArgs): void
Raises the visibleChanged event.
Occurs after the sheet name has changed.
Angular 2 component for the Sheet control.
The wj-sheet component must be contained in a WjFlexSheet component.
Use the wj-sheet component to add Sheet controls to your Angular 2 applications. For details about Angular 2 markup syntax, see Angular 2 Markup.
The WjSheet component is derived from the Sheet control and inherits all its properties, events and methods.