[{"id":"b66f8b1e-cc14-4e89-9679-abd5687d283d","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"569bb90a-ea68-46c6-96f1-ab151c120714","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5eb52f08-2d1a-4362-9ffc-4871bdc10f3f","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"341dd607-b97d-4d70-bde2-53acda6b6c95","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"05349273-414f-4208-9ea2-c4fc8f4ea2cb","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"86089f76-b778-4d52-821e-6f27de3df613","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b81e4fd6-1fc5-43a0-a258-b6e16a5cbec6","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8aa8ce31-43e4-438e-951f-241608435260","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"37343f41-6ec2-4c7e-b21d-2cc18d5ce1e0","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5915e52f-64f8-4146-b8bd-81bead6324a3","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"836ba889-af9e-460d-a4cc-c24d922795f2","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4ae14b06-bb68-4394-a210-a46b8f028346","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d8f42066-e9dc-4411-bdcf-43b1a203370c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"7ef86f16-b1a0-49f7-9592-612b9be02b25","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b29c7775-a9a4-451e-a1b5-01d19ed5ca5e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"e56f3989-8f81-46af-90fa-a4813eeb976f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"2526c963-f170-45a8-923e-91b0712a9810","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"24575cf0-501a-44f9-8426-c40f8f4b5552","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1a6f8d7f-acd6-42be-8c4f-f464c6218381","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"82b176fd-5cab-498c-909e-8fa7d29c38d8","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1708b3a9-4f37-44a8-8f0e-f9a2d2e5d940","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"c9ac246e-29fb-4bc4-8231-8439795bb590","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"94f2a5c3-2539-436a-af75-23fbbd1a3957","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d99594f4-2d40-4df4-9419-ba2ca6aa3f7f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"fd66e72d-0f10-4f57-9807-6db26290ab2e","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8f344863-503d-4bc3-a594-3815e7d55f5c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"9be82601-de9d-4c18-948a-23ab6f4dd431","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"6495f3c0-b463-47e0-b08a-ca949672211e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b4bede08-3f08-4839-ba4a-abc7ac195bde","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4afcdfc0-3ff5-4f2b-a223-f8fc042a5bbe","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"422062c4-fa40-4771-a86f-008efe6d86e5","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d87e8013-86a7-4840-8d25-6f62e14eb4ac","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a6acedfd-4043-4c64-a5d1-aec3326df9e7","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"dbdc0b24-06c4-48b9-8d6c-7455119dc773","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a3856849-954a-4cfc-96a6-382e530d3638","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4a39306b-ffa5-433d-80a3-28e41f929b72","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]}]
下表列出了gc-spread-sheets元素中的所有属性。
属性 | SpreadJS API | 类型 | 注释 |
---|---|---|---|
name | Workbook.name | string | |
allowUserZoom | Workbook.options.allowUserZoom = value | boolean | |
allowUserResize | Workbook.options.allowUserResize = value | boolean | |
tabStripVisible | Workbook.options.tabstripvisible = value | boolean | |
tabEditable | Workbook.options.tabEditable = value | boolean | |
newTabVisible | Workbook.options.newTabVisible = value | boolean | |
allowUserEditFormula | Workbook.options.allowUserEditFormula = value | boolean | |
autoFitType | Workbook.options.autofittype = value | GC.Spread.Sheets.AutoFitType | |
allowUserDragFill | Workbook.options.allowUserDragfill = value | boolean | |
allowUserDragDrop | Workbook.options.allowUserDragDrop = value | boolean | |
allowUserDragMerge | Workbook.options.allowUserDragMerge = value | boolean | |
allowUndo | Workbook.options.allowUndo = value | boolean | |
allowUserDeselect | Workbook.options.allowUserDeselect = value | boolean | |
allowSheetReorder | Workbook.options.allowSheetReorder = value | boolean | |
allowContextMenu | Workbook.options.allowContextMenu = value | boolean | |
allowCopyPasteExcelStyle | Workbook.options.allowCopyPasteExcelStyle = value | boolean | |
allowExtendPasteRange | Workbook.options.allowExtendPasteRange = value | boolean | |
cutCopyIndicatorVisible | Workbook.options.cutCopyIndicatorVisible = value | boolean | |
cutCopyIndicatorBorderColor | Workbook.options.cutCopyIndicatorBorderColor = value | string | |
copyPasteHeaderOptions | Workbook.options.copyPasteHeaderOptions = value | GC.Spread.Sheets.CopyPasteHeaderOptions | |
defaultDragFillType | Workbook.options.defaultDragFillType = value | GC.Spread.Sheets.Fill.AutoFillType | |
enableFormulaTextbox | Workbook.options.enableFormulaTextbox = value | boolean | |
hideSelection | Workbook.options.hideSelection = value | boolean | |
highlightInvalidData | Workbook.options.highlightInvalidData = value | boolean | |
referenceStyle | Workbook.options.referenceStyle = value | GC.Spread.Sheets.ReferenceStyle | |
backColor | Workbook.options.backColor = value | string | |
grayAreaBackColor | Workbook.options.grayAreaBackColor = value | string | |
backgroundImage | Workbook.options.backgroundImage = value | string | |
backgroundImageLayout | Workbook.options.backgroundImageLayout = value | GC.Spread.Sheets.ImageLayout | |
resizeZeroIndicator | Workbook.options.resizeZeroIndicator = value | GC.Spread.Sheets.ResizeZeroIndicator | |
showVerticalScrollbar | Workbook.options.showVerticalScrollbar = value | boolean | |
showHorizontalScrollbar | Workbook.options.showHorizontalScrollbar = value | boolean | |
ShowScrollTip | Workbook.options.showScrollTip = value | GC.Spread.Sheets.ShowScrollTip | |
ShowResizeTip | Workbook.options.showResizeTip = value | GC.Spread.Sheets.ShowResizeTip | |
showDragDropTip | Workbook.options.showDragDropTip = value | boolean | |
showDragFillTip | Workbook.options.showDragFillTip = value | boolean | |
showDragFillSmartTag | Workbook.options.showDragFillSmartTag = value | boolean | |
scrollbarShowMax | Workbook.options.scrollbarShowMax = value | boolean | |
scrollbarMaxAlign | Workbook.options.scrollbarMaxAlign = value | boolean | |
scrollIgnoreHidden | Workbook.options.scrollIgnoreHidden = value | boolean | |
tabStripRatio | Workbook.options.tabStripRatio = value | number | |
tabNavigationVisible | Workbook.options.tabNavigationVisible = value | boolean | |
useTouchLayout | Workbook.options.useTouchLayout = value | boolean | |
hostStyle | any | 宿主元素的样式,与angular的样式绑定相同(例如,宽度:400px,高度:600px}。 | |
hostClass | string | 宿主元素的类名。 |
以下示例显示如何使用sheet元素:
@Component({
selector: 'my-app',
template: `<gc-spread-sheets [backColor]="spreadBackColor" [hostStyle]="hostStyle">
</gc-spread-sheets>`,
})
export class AppComponent {
spreadBackColor = 'aliceblue';
hostStyle = {
width: '800px',
height: '600px'
};
}
下表列出了表单事件:
属性 | SpreadJS API | 注释 |
---|---|---|
workbookInitialized | 返回表单实例,args {spread:workbook} | |
validationError | GC.Spread.Sheets.Events.ValidationError | |
cellClick | GC.Spread.Sheets.Events.CellClick | |
cellDoubleClick | GC.Spread.Sheets.Events.CellDoubleClick | |
enterCell | GC.Spread.Sheets.Events.EnterCell | |
leaveCell | GC.Spread.Sheets.Events.LeaveCell | |
valueChanged | GC.Spread.Sheets.Events.ValueChanged | |
topRowChanged | GC.Spread.Sheets.Events.TopRowChanged | |
leftColumnChanged | GC.Spread.Sheets.Events.LeftColumnChanged | |
invalidOperation | GC.Spread.Sheets.Events.InvalidOperation | |
rangeFiltering | GC.Spread.Sheets.Events.RangeFiltering | |
rangeFiltered | GC.Spread.Sheets.Events.RangeFiltered | |
tableFiltering | GC.Spread.Sheets.Events.TableFiltering | |
tableFiltered | GC.Spread.Sheets.Events.TableFiltered | |
rangeSorting | GC.Spread.Sheets.Events.RangeSorting | |
rangeSorted | GC.Spread.Sheets.Events.RangeSorted | |
clipboardChanging | GC.Spread.Sheets.Events.ClipboardChanging | |
clipboardChanged | GC.Spread.Sheets.Events.ClipboardChanged | |
clipboardPasting | GC.Spread.Sheets.Events.ClipboardPasting | |
clipboardPasted | GC.Spread.Sheets.Events.ClipboardPasted | |
columnWidthChanging | GC.Spread.Sheets.Events.ColumnWidthChanging | |
columnWidthChanged | GC.Spread.Sheets.Events.ColumnWidthChanged | |
rowHeightChanging | GC.Spread.Sheets.Events.RowHeightChanging | |
rowHeightChanged | GC.Spread.Sheets.Events.RowHeightChanged | |
dragDropBlock | GC.Spread.Sheets.Events.DragDropBlock | |
dragDropBlockCompleted | GC.Spread.Sheets.Events.DragDropBlockCompleted | |
dragFillBlock | GC.Spread.Sheets.Events.DragFillBlock | |
dragFillBlockCompleted | GC.Spread.Sheets.Events.DragFillBlockCompleted | |
editStarting | GC.Spread.Sheets.Events.EditStarting | |
editChange | GC.Spread.Sheets.Events.EditChange | |
editEnding | GC.Spread.Sheets.Events.EditEnding | |
editEnd | GC.Spread.Sheets.Events.EditEnd | |
editEnded | GC.Spread.Sheets.Events.EditEnded | |
rangeGroupStateChanging | GC.Spread.Sheets.Events.RangeGroupStateChanging | |
rangeGroupStateChanged | GC.Spread.Sheets.Events.RangeGroupStateChanged | |
selectionChanging | GC.Spread.Sheets.Events.SelectionChanging | |
selectionChanged | GC.Spread.Sheets.Events.SelectionChanged | |
sheetTabClick | GC.Spread.Sheets.Events.SheetTabClick | |
sheetTabDoubleClick | GC.Spread.Sheets.Events.SheetTabDoubleClick | |
sheetNameChanging | GC.Spread.Sheets.Events.SheetNameChanging | |
sheetNameChanged | GC.Spread.Sheets.Events.SheetNameChanged | |
userZooming | GC.Spread.Sheets.Events.UserZooming | |
userFormulaEntered | GC.Spread.Sheets.Events.UserFormulaEntered | |
cellChanged | GC.Spread.Sheets.Events.CellChanged | |
columnChanged | GC.Spread.Sheets.Events.ColumnChanged | |
rowChanged | GC.Spread.Sheets.Events.RowChanged | |
activeSheetChanging | GC.Spread.Sheets.Events.ActiveSheetChanging | |
activeSheetChanged | GC.Spread.Sheets.Events.ActiveSheetChanged | |
sparklineChanged | GC.Spread.Sheets.Events.SparklineChanged | |
rangeChanged | GC.Spread.Sheets.Events.RangeChanged | |
buttonClicked | GC.Spread.Sheets.Events.ButtonClicked | |
editorStatusChanged | GC.Spread.Sheets.Events.EditorStatusChanged | |
floatingObjectChanged | GC.Spread.Sheets.Events.FloatingObjectChanged | |
floatingObjectSelectionChanged | GC.Spread.Sheets.Events.FloatingObjectSelectionChanged | |
pictureChanged | GC.Spread.Sheets.Events.PictureChanged | |
floatingObjectRemoving | GC.Spread.Sheets.Events.FloatingObjectRemoving | |
floatingObjectRemoved | GC.Spread.Sheets.Events.FloatingObjectRemoved | |
pictureSelectionChanged | GC.Spread.Sheets.Events.PictureSelectionChanged | |
floatingObjectLoaded | GC.Spread.Sheets.Events.FloatingObjectLoaded | |
touchToolStripOpening | GC.Spread.Sheets.Events.TouchToolStripOpening | |
commentChanged | GC.Spread.Sheets.Events.CommentChanged | |
commentRemoving | GC.Spread.Sheets.Events.CommentRemoving | |
commentRemoved | GC.Spread.Sheets.Events.CommentRemoved | |
slicerChanged | GC.Spread.Sheets.Events.SlicerChanged |
The following example uses an event:
@Component({
selector: 'my-app',
template: `<gc-spread-sheets (workbookInitialized)="workbookInit($event)"
(validationError)="validationError($event)">
</gc-spread-sheets>`,
})
export class AppComponent {
workbookInit (args) {
//do something
}
validationError (args) {
//do something
}
}
下表列出了子元素:
子元素 | SpreadJS API | 数量 |
---|---|---|
gc-worksheet | GC.Spread.Sheets.Worksheet | 任意 |