- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
-
GC.Spread.Sheets
- Classes
-
Interfaces
- IImageSize
- FloatingObjectLoadedEventArgs
- FormattedData
- IActiveSheetChangedEventArgs
- IActiveSheetChangingEventArgs
- IBaseSpreadOption
- IBounds
- IButtonClickedEventArgs
- ICalendarOption
- ICellButton
- ICellChangedEventArgs
- ICellClickEventArgs
- ICellColorSortInfo
- ICellDoubleClickEventArgs
- ICellPosition
- ICellsInfo
- IClearChangeInfo
- IClipboardChangedEventArgs
- IClipboardChangingEventArgs
- IClipboardPastedEventArgs
- IClipboardPastingEventArgs
- IColorPickerGroup
- IColorPickerOption
- IColumn
- IColumnBindingInfo
- IColumnChangedEventArgs
- IColumnWidthChangedEventArgs
- IColumnWidthChangingEventArgs
- ICommentChangedEventArgs
- ICommentRemovedEventArgs
- ICommentRemovingEventArgs
- ICopyData
- ICustomSortInfo
- IDirtyCellInfo
- IDragDropBlockCompletedEventArgs
- IAddColumnButtonOption
- IAddRowButtonOption
- IDragDropBlockEventArgs
- IDragFillBlockCompletedEventArgs
- IAppDocProps
- IDragFillBlockEventArgs
- IBuiltInFileIcons
- ICoreDocProps
- IDropdown
- IEditChangeEventArgs
- ICustomDocPropsManager
- ICustomDocumentProperty
- IEditEndedEventArgs
- IEditEndingEventArgs
- IDocProps
- IRange
- IEditorStatusChangedEventArgs
- IEditStartingEventArgs
- IEnterCellEventArgs
- IExternalReference
- IExternalReferenceDetail
- IFilterButtonHitInfo
- IFloatingObjectChangedEventArgs
- IFloatingObjectRemovedEventArgs
- IFloatingObjectRemovingEventArgs
- IFloatingObjectSelectionChangedEventArgs
- IFontColorSortInfo
- IFormulaInfo
- IFormulaRangeHitInfo
- IGradientFill
- IGradientPathFill
- IHitTestCellTypeHitInfo
- IHitTestCommentHitInfo
- IHitTestDragInfo
- IHitTestFloatingObjectHitInfo
- IHitTestFooterCornerInfo
- IHitTestInformation
- IHitTestOutlineHitInfo
- IHitTestResizeInfo
- IHitTestScrollBarInfo
- IHyperlink
- IIHitTestTabStripInfo
- IIcon
- IInvalidOperationEventArgs
- ILabelOptions
- ILeaveCellEventArgs
- ILeftColumnChangedEventArgs
- IListItem
- IListLayout
- IListOption
- IMaskType
- IMonthPickerOption
- IMultiColumnOption
- IOutlineColumnCheckStatusChanged
- IOutlineHitInfo
- IParamRange
- IPasteData
- IPatternFill
- IPictureChangedEventArgs
- IPictureSelectionChangedEventArgs
- IPivotTableChangedEventArgs
- IProtectionOptions
- IRangeChangedEventArgs
- IRangeFilterClearedEventArgs
- IRangeFilterClearingEventArgs
- IRangeFilteredEventArgs
- IRangeFilteringEventArgs
- IRangeGroupStateChangedEventArgs
- IRangeGroupStateChangingEventArgs
- IRangeSortedEventArgs
- IRangeSortingEventArgs
- IRowChangedEventArgs
- IRowHeightChangedEventArgs
- IRowHeightChangingEventArgs
- ISelectionChangedEventArgs
- ISelectionChangingEventArgs
- ISetBorderOptions
- IShapeChangedEventArgs
- IShapeRemovedEventArgs
- IShapeRemovingEventArgs
- IShapeSelectionChangedEventArgs
- ISheetChangedEventArgs
- ISheetChangingEventArgs
- ISheetDefaultOption
- ISheetNameChangedEventArgs
- ISheetNameChangingEventArgs
- ISheetTabClickEventArgs
- ISheetTabDoubleClickEventArgs
- ISlicerChangedEventArgs
- ISliderOption
- ISortOptions
- ISparklineChangedEventArgs
- ITableFilterClearedEventArgs
- ITableFilterClearingEventArgs
- ITableFilteredEventArgs
- ITableFilteringEventArgs
- ITimePickerOption
- ITimePickerValue
- ITopRowChangedEventArgs
- ITouchToolStripOpeningEventArgs
- IUserFormulaEnteredEventArgs
- IUserZoomingEventArgs
- IValidationErrorEventArgs
- IValueChangedEventArgs
- IValueSortInfo
- IWorkBookDefaultOptions
- IWorkbookHitTestInformation
- IWorkbookOptions
- IWorkFlowItem
- IWorkFlowOption
- IWorkSheetGridlineOption
-
IWorksheetOptions
- IWorkSheetSheetAreaOffsetOption
- SheetTabInfo
- IDecoration
- ICornerFold
- IParameter
- ISheetTabStyle
- ISheetNameTabStyleMap
- ISortState
- Enumerations
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Excel
GC.Spread.Sheets.IWorksheetOptions
接口: IWorksheetOptions
Spread.Sheets.IWorksheetOptions
Table of contents
属性
- addColumnButtonOption
- addRowButtonOption
- allowCellOverflow
- clipBoardOptions
- colHeaderAutoText
- colHeaderAutoTextIndex
- colHeaderVisible
- frozenlineColor
- gridline
- isProtected
- keepUnknownFormulas
- protectionOptions
- rightToLeft
- rowHeaderAutoText
- rowHeaderAutoTextIndex
- rowHeaderVisible
- selectionBackColor
- selectionBorderColor
- sheetAreaOffset
- sheetTabColor
- showFormulas
- showZeros
属性
addColumnButtonOption
• Optional addColumnButtonOption: IAddColumnButtonOption
添加列按钮的选项。
addRowButtonOption
• Optional addRowButtonOption: IAddRowButtonOption
添加行按钮的选项。
allowCellOverflow
• allowCellOverflow: boolean
指示数据是否可以溢出到相邻的空单元格中。
clipBoardOptions
• clipBoardOptions: ClipboardPasteOptions
剪贴板选项。
colHeaderAutoText
• colHeaderAutoText: HeaderAutoText
指示列标题是显示字母、数字还是空白。
colHeaderAutoTextIndex
• colHeaderAutoTextIndex: HeaderAutoText
指定当存在多个列标题行时，哪个列标题行显示自动文本。
colHeaderVisible
• colHeaderVisible: boolean
指示列标题是否可见。
frozenlineColor
• frozenlineColor: string
用于表示冻结线颜色的颜色字符串，例如“red”、“#FFFF00”、“rgb(255,0,0)”、“Accent 5”等。
gridline
• gridline: IWorkSheetGridlineOption
网格线的选项。
isProtected
• isProtected: boolean
指示此工作表上标记为受保护的单元格是否无法编辑。
keepUnknownFormulas
• keepUnknownFormulas: boolean
指示未知公式是否可以包含在工作表 JSON 数据中
protectionOptions
• protectionOptions: IProtectionOptions
表单保护配置项
rightToLeft
• rightToLeft: boolean
指示工作表是否从右向左渲染。
rowHeaderAutoText
• rowHeaderAutoText: HeaderAutoText
指示行标头是显示字母还是数字还是空白
rowHeaderAutoTextIndex
• rowHeaderAutoTextIndex: HeaderAutoText
指定有多个行标头列时哪个行标头列显示自动文本
rowHeaderVisible
• rowHeaderVisible: boolean
指示行是否可见
selectionBackColor
• selectionBackColor: string
工作表的选定区域背景颜色
selectionBorderColor
• selectionBorderColor: string
工作表的选定区域边框颜色
sheetAreaOffset
• sheetAreaOffset: IWorkSheetSheetAreaOffsetOption
SheetAreaOffset 的选项
sheetTabColor
• sheetTabColor: string
用于表示工作表标签颜色的颜色字符串，例如"red"，"#FFFF00"，"rgb(255,0,0)"，"Accent 5"等
showFormulas
• showFormulas: boolean
指示是否显示公式字符串而不是公式结果
showZeros
• showZeros: boolean
指示是否在包含零值的单元格中显示0。默认为true