# GC.Spread.Sheets

## Content

# Namespace: Sheets

[GC](GC).[Spread](GC.Spread).Sheets

## Table of contents

### Namespaces

- [AutoMerge](GC.Spread.Sheets.AutoMerge)
- [Barcode](GC.Spread.Sheets.Barcode)
- [Bindings](GC.Spread.Sheets.Bindings)
- [CalcEngine](GC.Spread.Sheets.CalcEngine)
- [CellState](GC.Spread.Sheets.CellState)
- [CellTypes](GC.Spread.Sheets.CellTypes)
- [Charts](GC.Spread.Sheets.Charts)
- [Commands](GC.Spread.Sheets.Commands)
- [Comments](GC.Spread.Sheets.Comments)
- [ConditionalFormatting](GC.Spread.Sheets.ConditionalFormatting)
- [ContextMenu](GC.Spread.Sheets.ContextMenu)
- [DataValidation](GC.Spread.Sheets.DataValidation)
- [Fill](GC.Spread.Sheets.Fill)
- [Filter](GC.Spread.Sheets.Filter)
- [FloatingObjects](GC.Spread.Sheets.FloatingObjects)
- [FormulaPanel](GC.Spread.Sheets.FormulaPanel)
- [FormulaTextBox](GC.Spread.Sheets.FormulaTextBox)
- [GanttSheet](GC.Spread.Sheets.GanttSheet)
- [Hyperlink](GC.Spread.Sheets.Hyperlink)
- [IO](GC.Spread.Sheets.IO)
- [InputMask](GC.Spread.Sheets.InputMask)
- [NameBox](GC.Spread.Sheets.NameBox)
- [OutlineColumn](GC.Spread.Sheets.OutlineColumn)
- [Outlines](GC.Spread.Sheets.Outlines)
- [PDF](GC.Spread.Sheets.PDF)
- [Print](GC.Spread.Sheets.Print)
- [Search](GC.Spread.Sheets.Search)
- [Shapes](GC.Spread.Sheets.Shapes)
- [Slicers](GC.Spread.Sheets.Slicers)
- [Sparklines](GC.Spread.Sheets.Sparklines)
- [StatusBar](GC.Spread.Sheets.StatusBar)
- [TableSheet](GC.Spread.Sheets.TableSheet)
- [Tables](GC.Spread.Sheets.Tables)
- [Touch](GC.Spread.Sheets.Touch)

### Enumerations

- [AllSheetsListVisibility](../enums/GC.Spread.Sheets.AllSheetsListVisibility)
- [AutoFitType](../enums/GC.Spread.Sheets.AutoFitType)
- [ButtonImageType](../enums/GC.Spread.Sheets.ButtonImageType)
- [ButtonPosition](../enums/GC.Spread.Sheets.ButtonPosition)
- [ButtonVisibility](../enums/GC.Spread.Sheets.ButtonVisibility)
- [CalculationMode](../enums/GC.Spread.Sheets.CalculationMode)
- [CalculationType](../enums/GC.Spread.Sheets.CalculationType)
- [CalendarPage](../enums/GC.Spread.Sheets.CalendarPage)
- [CalendarStartDay](../enums/GC.Spread.Sheets.CalendarStartDay)
- [CaptionAlignment](../enums/GC.Spread.Sheets.CaptionAlignment)
- [CellStatesType](../enums/GC.Spread.Sheets.CellStatesType)
- [ClearPendingChangeType](../enums/GC.Spread.Sheets.ClearPendingChangeType)
- [ClipboardActionType](../enums/GC.Spread.Sheets.ClipboardActionType)
- [ClipboardPasteOptions](../enums/GC.Spread.Sheets.ClipboardPasteOptions)
- [CopyPasteHeaderOptions](../enums/GC.Spread.Sheets.CopyPasteHeaderOptions)
- [CopyToOptions](../enums/GC.Spread.Sheets.CopyToOptions)
- [CornerPosition](../enums/GC.Spread.Sheets.CornerPosition)
- [DropDownType](../enums/GC.Spread.Sheets.DropDownType)
- [DropdownListValue](../enums/GC.Spread.Sheets.DropdownListValue)
- [EditorStatus](../enums/GC.Spread.Sheets.EditorStatus)
- [FileType](../enums/GC.Spread.Sheets.FileType)
- [GroupSort](../enums/GC.Spread.Sheets.GroupSort)
- [HeaderAutoText](../enums/GC.Spread.Sheets.HeaderAutoText)
- [HeaderOptions](../enums/GC.Spread.Sheets.HeaderOptions)
- [HorizontalAlign](../enums/GC.Spread.Sheets.HorizontalAlign)
- [HorizontalPosition](../enums/GC.Spread.Sheets.HorizontalPosition)
- [HyperlinkTargetType](../enums/GC.Spread.Sheets.HyperlinkTargetType)
- [IconPosition](../enums/GC.Spread.Sheets.IconPosition)
- [ImageLayout](../enums/GC.Spread.Sheets.ImageLayout)
- [ImeMode](../enums/GC.Spread.Sheets.ImeMode)
- [InsertShiftCell](../enums/GC.Spread.Sheets.InsertShiftCell)
- [InvalidOperationType](../enums/GC.Spread.Sheets.InvalidOperationType)
- [LabelAlignment](../enums/GC.Spread.Sheets.LabelAlignment)
- [LabelVisibility](../enums/GC.Spread.Sheets.LabelVisibility)
- [LayoutDirection](../enums/GC.Spread.Sheets.LayoutDirection)
- [LayoutDisplayAs](../enums/GC.Spread.Sheets.LayoutDisplayAs)
- [LineStyle](../enums/GC.Spread.Sheets.LineStyle)
- [NumbersFitMode](../enums/GC.Spread.Sheets.NumbersFitMode)
- [OpenMode](../enums/GC.Spread.Sheets.OpenMode)
- [PatternType](../enums/GC.Spread.Sheets.PatternType)
- [RangeChangedAction](../enums/GC.Spread.Sheets.RangeChangedAction)
- [ReferenceStyle](../enums/GC.Spread.Sheets.ReferenceStyle)
- [ResizeMode](../enums/GC.Spread.Sheets.ResizeMode)
- [ResizeZeroIndicator](../enums/GC.Spread.Sheets.ResizeZeroIndicator)
- [RowColumnStates](../enums/GC.Spread.Sheets.RowColumnStates)
- [ScrollbarAppearance](../enums/GC.Spread.Sheets.ScrollbarAppearance)
- [SelectionPolicy](../enums/GC.Spread.Sheets.SelectionPolicy)
- [SelectionUnit](../enums/GC.Spread.Sheets.SelectionUnit)
- [SheetArea](../enums/GC.Spread.Sheets.SheetArea)
- [SheetTabVisible](../enums/GC.Spread.Sheets.SheetTabVisible)
- [SheetType](../enums/GC.Spread.Sheets.SheetType)
- [ShowResizeTip](../enums/GC.Spread.Sheets.ShowResizeTip)
- [ShowScrollTip](../enums/GC.Spread.Sheets.ShowScrollTip)
- [SortState](../enums/GC.Spread.Sheets.SortState)
- [StorageType](../enums/GC.Spread.Sheets.StorageType)
- [TabStripPosition](../enums/GC.Spread.Sheets.TabStripPosition)
- [TextDecorationType](../enums/GC.Spread.Sheets.TextDecorationType)
- [UsedRangeType](../enums/GC.Spread.Sheets.UsedRangeType)
- [ValueType](../enums/GC.Spread.Sheets.ValueType)
- [VertAlign](../enums/GC.Spread.Sheets.VertAlign)
- [VerticalAlign](../enums/GC.Spread.Sheets.VerticalAlign)
- [VerticalPosition](../enums/GC.Spread.Sheets.VerticalPosition)
- [VisualState](../enums/GC.Spread.Sheets.VisualState)

### Classes

- [CellRange](../classes/GC.Spread.Sheets.CellRange)
- [ColorScheme](../classes/GC.Spread.Sheets.ColorScheme)
- [Events](../classes/GC.Spread.Sheets.Events)
- [LineBorder](../classes/GC.Spread.Sheets.LineBorder)
- [NameInfo](../classes/GC.Spread.Sheets.NameInfo)
- [PivotTableManager](../classes/GC.Spread.Sheets.PivotTableManager)
- [Point](../classes/GC.Spread.Sheets.Point)
- [Range](../classes/GC.Spread.Sheets.Range)
- [Rect](../classes/GC.Spread.Sheets.Rect)
- [Style](../classes/GC.Spread.Sheets.Style)
- [Theme](../classes/GC.Spread.Sheets.Theme)
- [ThemeColors](../classes/GC.Spread.Sheets.ThemeColors)
- [Themes](../classes/GC.Spread.Sheets.Themes)
- [Workbook](../classes/GC.Spread.Sheets.Workbook)
- [Worksheet](../classes/GC.Spread.Sheets.Worksheet)

### Interfaces

- [FloatingObjectLoadedEventArgs](../interfaces/GC.Spread.Sheets.FloatingObjectLoadedEventArgs)
- [FormattedData](../interfaces/GC.Spread.Sheets.FormattedData)
- [IActiveSheetChangedEventArgs](../interfaces/GC.Spread.Sheets.IActiveSheetChangedEventArgs)
- [IActiveSheetChangingEventArgs](../interfaces/GC.Spread.Sheets.IActiveSheetChangingEventArgs)
- [IBaseSpreadOption](../interfaces/GC.Spread.Sheets.IBaseSpreadOption)
- [IBounds](../interfaces/GC.Spread.Sheets.IBounds)
- [IButtonClickedEventArgs](../interfaces/GC.Spread.Sheets.IButtonClickedEventArgs)
- [ICalendarOption](../interfaces/GC.Spread.Sheets.ICalendarOption)
- [ICellButton](../interfaces/GC.Spread.Sheets.ICellButton)
- [ICellChangedEventArgs](../interfaces/GC.Spread.Sheets.ICellChangedEventArgs)
- [ICellClickEventArgs](../interfaces/GC.Spread.Sheets.ICellClickEventArgs)
- [ICellColorSortInfo](../interfaces/GC.Spread.Sheets.ICellColorSortInfo)
- [ICellDoubleClickEventArgs](../interfaces/GC.Spread.Sheets.ICellDoubleClickEventArgs)
- [ICellPosition](../interfaces/GC.Spread.Sheets.ICellPosition)
- [ICellsInfo](../interfaces/GC.Spread.Sheets.ICellsInfo)
- [IClearChangeInfo](../interfaces/GC.Spread.Sheets.IClearChangeInfo)
- [IClipboardChangedEventArgs](../interfaces/GC.Spread.Sheets.IClipboardChangedEventArgs)
- [IClipboardChangingEventArgs](../interfaces/GC.Spread.Sheets.IClipboardChangingEventArgs)
- [IClipboardPastedEventArgs](../interfaces/GC.Spread.Sheets.IClipboardPastedEventArgs)
- [IClipboardPastingEventArgs](../interfaces/GC.Spread.Sheets.IClipboardPastingEventArgs)
- [IColorPickerGroup](../interfaces/GC.Spread.Sheets.IColorPickerGroup)
- [IColorPickerOption](../interfaces/GC.Spread.Sheets.IColorPickerOption)
- [IColumn](../interfaces/GC.Spread.Sheets.IColumn)
- [IColumnBindingInfo](../interfaces/GC.Spread.Sheets.IColumnBindingInfo)
- [IColumnChangedEventArgs](../interfaces/GC.Spread.Sheets.IColumnChangedEventArgs)
- [IColumnWidthChangedEventArgs](../interfaces/GC.Spread.Sheets.IColumnWidthChangedEventArgs)
- [IColumnWidthChangingEventArgs](../interfaces/GC.Spread.Sheets.IColumnWidthChangingEventArgs)
- [ICommentChangedEventArgs](../interfaces/GC.Spread.Sheets.ICommentChangedEventArgs)
- [ICommentRemovedEventArgs](../interfaces/GC.Spread.Sheets.ICommentRemovedEventArgs)
- [ICommentRemovingEventArgs](../interfaces/GC.Spread.Sheets.ICommentRemovingEventArgs)
- [ICopyData](../interfaces/GC.Spread.Sheets.ICopyData)
- [ICornerFold](../interfaces/GC.Spread.Sheets.ICornerFold)
- [ICustomSortInfo](../interfaces/GC.Spread.Sheets.ICustomSortInfo)
- [IDecoration](../interfaces/GC.Spread.Sheets.IDecoration)
- [IDirtyCellInfo](../interfaces/GC.Spread.Sheets.IDirtyCellInfo)
- [IDragDropBlockCompletedEventArgs](../interfaces/GC.Spread.Sheets.IDragDropBlockCompletedEventArgs)
- [IDragDropBlockEventArgs](../interfaces/GC.Spread.Sheets.IDragDropBlockEventArgs)
- [IDragFillBlockCompletedEventArgs](../interfaces/GC.Spread.Sheets.IDragFillBlockCompletedEventArgs)
- [IDragFillBlockEventArgs](../interfaces/GC.Spread.Sheets.IDragFillBlockEventArgs)
- [IDropdown](../interfaces/GC.Spread.Sheets.IDropdown)
- [IEditChangeEventArgs](../interfaces/GC.Spread.Sheets.IEditChangeEventArgs)
- [IEditEndedEventArgs](../interfaces/GC.Spread.Sheets.IEditEndedEventArgs)
- [IEditEndingEventArgs](../interfaces/GC.Spread.Sheets.IEditEndingEventArgs)
- [IEditStartingEventArgs](../interfaces/GC.Spread.Sheets.IEditStartingEventArgs)
- [IEditorStatusChangedEventArgs](../interfaces/GC.Spread.Sheets.IEditorStatusChangedEventArgs)
- [IEnterCellEventArgs](../interfaces/GC.Spread.Sheets.IEnterCellEventArgs)
- [IExternalReference](../interfaces/GC.Spread.Sheets.IExternalReference)
- [IExternalReferenceDetail](../interfaces/GC.Spread.Sheets.IExternalReferenceDetail)
- [IFilterButtonHitInfo](../interfaces/GC.Spread.Sheets.IFilterButtonHitInfo)
- [IFloatingObjectChangedEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectChangedEventArgs)
- [IFloatingObjectRemovedEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectRemovedEventArgs)
- [IFloatingObjectRemovingEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectRemovingEventArgs)
- [IFloatingObjectSelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectSelectionChangedEventArgs)
- [IFontColorSortInfo](../interfaces/GC.Spread.Sheets.IFontColorSortInfo)
- [IFormulaInfo](../interfaces/GC.Spread.Sheets.IFormulaInfo)
- [IFormulaRangeHitInfo](../interfaces/GC.Spread.Sheets.IFormulaRangeHitInfo)
- [IGradientFill](../interfaces/GC.Spread.Sheets.IGradientFill)
- [IGradientPathFill](../interfaces/GC.Spread.Sheets.IGradientPathFill)
- [IHitTestCellTypeHitInfo](../interfaces/GC.Spread.Sheets.IHitTestCellTypeHitInfo)
- [IHitTestCommentHitInfo](../interfaces/GC.Spread.Sheets.IHitTestCommentHitInfo)
- [IHitTestDragInfo](../interfaces/GC.Spread.Sheets.IHitTestDragInfo)
- [IHitTestFloatingObjectHitInfo](../interfaces/GC.Spread.Sheets.IHitTestFloatingObjectHitInfo)
- [IHitTestFooterCornerInfo](../interfaces/GC.Spread.Sheets.IHitTestFooterCornerInfo)
- [IHitTestInformation](../interfaces/GC.Spread.Sheets.IHitTestInformation)
- [IHitTestOutlineHitInfo](../interfaces/GC.Spread.Sheets.IHitTestOutlineHitInfo)
- [IHitTestResizeInfo](../interfaces/GC.Spread.Sheets.IHitTestResizeInfo)
- [IHitTestScrollBarInfo](../interfaces/GC.Spread.Sheets.IHitTestScrollBarInfo)
- [IHyperlink](../interfaces/GC.Spread.Sheets.IHyperlink)
- [IIHitTestTabStripInfo](../interfaces/GC.Spread.Sheets.IIHitTestTabStripInfo)
- [IIcon](../interfaces/GC.Spread.Sheets.IIcon)
- [IInvalidOperationEventArgs](../interfaces/GC.Spread.Sheets.IInvalidOperationEventArgs)
- [ILabelOptions](../interfaces/GC.Spread.Sheets.ILabelOptions)
- [ILeaveCellEventArgs](../interfaces/GC.Spread.Sheets.ILeaveCellEventArgs)
- [ILeftColumnChangedEventArgs](../interfaces/GC.Spread.Sheets.ILeftColumnChangedEventArgs)
- [IListItem](../interfaces/GC.Spread.Sheets.IListItem)
- [IListLayout](../interfaces/GC.Spread.Sheets.IListLayout)
- [IListOption](../interfaces/GC.Spread.Sheets.IListOption)
- [IMaskType](../interfaces/GC.Spread.Sheets.IMaskType)
- [IMonthPickerOption](../interfaces/GC.Spread.Sheets.IMonthPickerOption)
- [IMultiColumnOption](../interfaces/GC.Spread.Sheets.IMultiColumnOption)
- [IOutlineColumnCheckStatusChanged](../interfaces/GC.Spread.Sheets.IOutlineColumnCheckStatusChanged)
- [IOutlineHitInfo](../interfaces/GC.Spread.Sheets.IOutlineHitInfo)
- [IParamRange](../interfaces/GC.Spread.Sheets.IParamRange)
- [IPasteData](../interfaces/GC.Spread.Sheets.IPasteData)
- [IPatternFill](../interfaces/GC.Spread.Sheets.IPatternFill)
- [IPictureChangedEventArgs](../interfaces/GC.Spread.Sheets.IPictureChangedEventArgs)
- [IPictureSelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.IPictureSelectionChangedEventArgs)
- [IPivotTableChangedEventArgs](../interfaces/GC.Spread.Sheets.IPivotTableChangedEventArgs)
- [IProtectionOptions](../interfaces/GC.Spread.Sheets.IProtectionOptions)
- [IRangeChangedEventArgs](../interfaces/GC.Spread.Sheets.IRangeChangedEventArgs)
- [IRangeFilterClearedEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilterClearedEventArgs)
- [IRangeFilterClearingEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilterClearingEventArgs)
- [IRangeFilteredEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilteredEventArgs)
- [IRangeFilteringEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilteringEventArgs)
- [IRangeGroupStateChangedEventArgs](../interfaces/GC.Spread.Sheets.IRangeGroupStateChangedEventArgs)
- [IRangeGroupStateChangingEventArgs](../interfaces/GC.Spread.Sheets.IRangeGroupStateChangingEventArgs)
- [IRangeSortedEventArgs](../interfaces/GC.Spread.Sheets.IRangeSortedEventArgs)
- [IRangeSortingEventArgs](../interfaces/GC.Spread.Sheets.IRangeSortingEventArgs)
- [IRowChangedEventArgs](../interfaces/GC.Spread.Sheets.IRowChangedEventArgs)
- [IRowHeightChangedEventArgs](../interfaces/GC.Spread.Sheets.IRowHeightChangedEventArgs)
- [IRowHeightChangingEventArgs](../interfaces/GC.Spread.Sheets.IRowHeightChangingEventArgs)
- [ISelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.ISelectionChangedEventArgs)
- [ISelectionChangingEventArgs](../interfaces/GC.Spread.Sheets.ISelectionChangingEventArgs)
- [ISetBorderOptions](../interfaces/GC.Spread.Sheets.ISetBorderOptions)
- [IShapeChangedEventArgs](../interfaces/GC.Spread.Sheets.IShapeChangedEventArgs)
- [IShapeRemovedEventArgs](../interfaces/GC.Spread.Sheets.IShapeRemovedEventArgs)
- [IShapeRemovingEventArgs](../interfaces/GC.Spread.Sheets.IShapeRemovingEventArgs)
- [IShapeSelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.IShapeSelectionChangedEventArgs)
- [ISheetChangedEventArgs](../interfaces/GC.Spread.Sheets.ISheetChangedEventArgs)
- [ISheetChangingEventArgs](../interfaces/GC.Spread.Sheets.ISheetChangingEventArgs)
- [ISheetDefaultOption](../interfaces/GC.Spread.Sheets.ISheetDefaultOption)
- [ISheetNameChangedEventArgs](../interfaces/GC.Spread.Sheets.ISheetNameChangedEventArgs)
- [ISheetNameChangingEventArgs](../interfaces/GC.Spread.Sheets.ISheetNameChangingEventArgs)
- [ISheetTabClickEventArgs](../interfaces/GC.Spread.Sheets.ISheetTabClickEventArgs)
- [ISheetTabDoubleClickEventArgs](../interfaces/GC.Spread.Sheets.ISheetTabDoubleClickEventArgs)
- [ISlicerChangedEventArgs](../interfaces/GC.Spread.Sheets.ISlicerChangedEventArgs)
- [ISliderOption](../interfaces/GC.Spread.Sheets.ISliderOption)
- [ISortOptions](../interfaces/GC.Spread.Sheets.ISortOptions)
- [ISparklineChangedEventArgs](../interfaces/GC.Spread.Sheets.ISparklineChangedEventArgs)
- [ITableFilterClearedEventArgs](../interfaces/GC.Spread.Sheets.ITableFilterClearedEventArgs)
- [ITableFilterClearingEventArgs](../interfaces/GC.Spread.Sheets.ITableFilterClearingEventArgs)
- [ITableFilteredEventArgs](../interfaces/GC.Spread.Sheets.ITableFilteredEventArgs)
- [ITableFilteringEventArgs](../interfaces/GC.Spread.Sheets.ITableFilteringEventArgs)
- [ITimePickerOption](../interfaces/GC.Spread.Sheets.ITimePickerOption)
- [ITimePickerValue](../interfaces/GC.Spread.Sheets.ITimePickerValue)
- [ITopRowChangedEventArgs](../interfaces/GC.Spread.Sheets.ITopRowChangedEventArgs)
- [ITouchToolStripOpeningEventArgs](../interfaces/GC.Spread.Sheets.ITouchToolStripOpeningEventArgs)
- [IUserFormulaEnteredEventArgs](../interfaces/GC.Spread.Sheets.IUserFormulaEnteredEventArgs)
- [IUserZoomingEventArgs](../interfaces/GC.Spread.Sheets.IUserZoomingEventArgs)
- [IValidationErrorEventArgs](../interfaces/GC.Spread.Sheets.IValidationErrorEventArgs)
- [IValueChangedEventArgs](../interfaces/GC.Spread.Sheets.IValueChangedEventArgs)
- [IValueSortInfo](../interfaces/GC.Spread.Sheets.IValueSortInfo)
- [IWorkBookDefaultOptions](../interfaces/GC.Spread.Sheets.IWorkBookDefaultOptions)
- [IWorkFlowItem](../interfaces/GC.Spread.Sheets.IWorkFlowItem)
- [IWorkFlowOption](../interfaces/GC.Spread.Sheets.IWorkFlowOption)
- [IWorkSheetGridlineOption](../interfaces/GC.Spread.Sheets.IWorkSheetGridlineOption)
- [IWorkSheetSheetAreaOffsetOption](../interfaces/GC.Spread.Sheets.IWorkSheetSheetAreaOffsetOption)
- [IWorkbookHitTestInformation](../interfaces/GC.Spread.Sheets.IWorkbookHitTestInformation)
- [IWorkbookOptions](../interfaces/GC.Spread.Sheets.IWorkbookOptions)
- [IWorksheetOptions](../interfaces/GC.Spread.Sheets.IWorksheetOptions)
- [SheetTabInfo](../interfaces/GC.Spread.Sheets.SheetTabInfo)

### Type aliases

- [CellValue](GC.Spread.Sheets#cellvalue)
- [ExportCsvOptions](GC.Spread.Sheets#exportcsvoptions)
- [ExportOptions](GC.Spread.Sheets#exportoptions)
- [ExportSSJsonOptions](GC.Spread.Sheets#exportssjsonoptions)
- [ExportXlsxOptions](GC.Spread.Sheets#exportxlsxoptions)
- [ExternalPartialValues](GC.Spread.Sheets#externalpartialvalues)
- [FileOptions](GC.Spread.Sheets#fileoptions)
- [ImportCsvOptions](GC.Spread.Sheets#importcsvoptions)
- [ImportOptions](GC.Spread.Sheets#importoptions)
- [ImportSSJsonOptions](GC.Spread.Sheets#importssjsonoptions)
- [ImportXlsxOptions](GC.Spread.Sheets#importxlsxoptions)
- [OpenOptions](GC.Spread.Sheets#openoptions)
- [PartialValues](GC.Spread.Sheets#partialvalues)
- [ProgressArgs](GC.Spread.Sheets#progressargs)
- [ProgressFunctionType](GC.Spread.Sheets#progressfunctiontype)
- [SaveOptions](GC.Spread.Sheets#saveoptions)

### Variables

- [LicenseKey](GC.Spread.Sheets#licensekey)

### Functions

- [findControl](GC.Spread.Sheets#findcontrol)
- [getTypeFromString](GC.Spread.Sheets#gettypefromstring)

## Type aliases

### <a id="cellvalue" name="cellvalue"></a> CellValue

Ƭ **CellValue**: `Object`

**`property`** {any} col - A key-value collection, which key is a col number, and value is cell value with any type.

#### Index signature

▪ [col: `number`]: `any`

___

### <a id="exportcsvoptions" name="exportcsvoptions"></a> ExportCsvOptions

Ƭ **ExportCsvOptions**: `Object`

**`property`** {GC.Spread.Sheets.FileType} fileType - The file type.

**`property`** {string} [encoding] - The csv encoding type, the default encoding type is 'UTF-8'.

**`property`** {string} [rowDelimiter] - The row delimiter that is appended to the end of the row, the default row delimiter is '\r\n'.

**`property`** {string} [columnDelimiter] - The column delimiter that is appended to the end of the column, the default column delimiter is ','.

**`property`** {object} [range] - The range info.

**`param`** The sheet index, the default sheet index is current active sheet index.

**`param`** The start row, the default row index is 0.

**`param`** The start column, the default column index is 0.

**`param`** The row count, the default row count is current active sheet row count.

**`param`** The column count, the default column count is current active sheet column count.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `columnDelimiter?` | `string` |
| `encoding?` | `string` |
| `range?` | { `column`: `number` ; `columnCount`: `number` ; `row`: `number` ; `rowCount`: `number` ; `sheetIndex`: `number`  } |
| `range.column` | `number` |
| `range.columnCount` | `number` |
| `range.row` | `number` |
| `range.rowCount` | `number` |
| `range.sheetIndex` | `number` |
| `rowDelimiter?` | `string` |

___

### <a id="exportoptions" name="exportoptions"></a> ExportOptions

Ƭ **ExportOptions**: [`FileOptions`](GC.Spread.Sheets#fileoptions) & [`ExportCsvOptions`](GC.Spread.Sheets#exportcsvoptions) \| [`ExportSSJsonOptions`](GC.Spread.Sheets#exportssjsonoptions) \| [`ExportXlsxOptions`](GC.Spread.Sheets#exportxlsxoptions)

___

### <a id="exportssjsonoptions" name="exportssjsonoptions"></a> ExportSSJsonOptions

Ƭ **ExportSSJsonOptions**: `Object`

**`property`** {GC.Spread.Sheets.FileType} fileType - The file type.

**`property`** {boolean} [includeBindingSource] - Whether to include the binding source when converting the workbook to json, default false.

**`property`** {boolean} [includeStyles] - Whether to include the style when converting the workbook to json, default true.

**`property`** {boolean} [includeFormulas] - Whether to include the formula when converting the workbook to json, default true.

**`property`** {boolean} [saveAsView] - Whether to apply the format string to exporting value when converting the workbook to json, default false.

**`property`** {boolean} [rowHeadersAsFrozenColumns] - Whether to treat the row headers as frozen columns when converting the workbook to json, default false.

**`property`** {boolean} [columnHeadersAsFrozenRows] - Whether to treat the column headers as frozen rows when converting the workbook to json, default false.

**`property`** {boolean} [includeAutoMergedCells] - Whether to include the automatically merged cells when converting the workbook to json, default false.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `columnHeadersAsFrozenRows?` | `boolean` |
| `includeAutoMergedCells?` | `boolean` |
| `includeBindingSource?` | `boolean` |
| `includeFormulas?` | `boolean` |
| `includeStyles?` | `boolean` |
| `rowHeadersAsFrozenColumns?` | `boolean` |
| `saveAsView?` | `boolean` |

___

### <a id="exportxlsxoptions" name="exportxlsxoptions"></a> ExportXlsxOptions

Ƭ **ExportXlsxOptions**: `Object`

**`property`** {GC.Spread.Sheets.FileType} fileType - The file type.

**`property`** {boolean} [includeBindingSource] - Whether to include the binding source when do save, default false.

**`property`** {boolean} [includeStyles] - Whether to include the style when do save, default true.

**`property`** {boolean} [includeFormulas] - Whether to include the formula when do save, default true.

**`property`** {boolean} [saveAsView] - Whether to apply the format string to exporting value when do save, default false.

**`property`** {boolean} [rowHeadersAsFrozenColumns] - Whether to treat the row headers as frozen columns when do save, default false.

**`property`** {boolean} [columnHeadersAsFrozenRows] - Whether to treat the column headers as frozen rows when do save, default false.

**`property`** {boolean} [includeAutoMergedCells] - Whether to include the automatically merged cells when do save, default false.

**`property`** {boolean} [includeCalcModelCache] - Whether to include the extra data of calculation. Can be faster when open the file with those data, default false.

**`property`** {boolean} [includeUnusedNames] - Whether to include the unused custom name when do save, default true.

**`property`** {boolean} [includeEmptyRegionCells] - Whether to include any empty cells(cells with no data or only style) outside the used data range, default true.

**`property`** {string} [password] - Set the password to open the workbook.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `columnHeadersAsFrozenRows?` | `boolean` |
| `includeAutoMergedCells?` | `boolean` |
| `includeBindingSource?` | `boolean` |
| `includeCalcModelCache?` | `boolean` |
| `includeEmptyRegionCells?` | `boolean` |
| `includeFormulas?` | `boolean` |
| `includeStyles?` | `boolean` |
| `includeUnusedNames?` | `boolean` |
| `password?` | `string` |
| `rowHeadersAsFrozenColumns?` | `boolean` |
| `saveAsView?` | `boolean` |

___

### <a id="externalpartialvalues" name="externalpartialvalues"></a> ExternalPartialValues

Ƭ **ExternalPartialValues**: `Object`

**`property`** {GC.Spread.Sheets.PartialValues} filePath - A key-value collection, which key is a file path string, and value is type of GC.Spread.Sheets.PartialValues.

#### Index signature

▪ [filePath: `string`]: [`PartialValues`](GC.Spread.Sheets#partialvalues)

___

### <a id="fileoptions" name="fileoptions"></a> FileOptions

Ƭ **FileOptions**: `Object`

**`property`** {GC.Spread.Sheets.FileType} fileType - The file type.

#### Type declaration

| Name | Type | Description |
| :------ | :------ | :------ |
| `fileType` | [`FileType`](../enums/GC.Spread.Sheets.FileType) | The file type. |

___

### <a id="importcsvoptions" name="importcsvoptions"></a> ImportCsvOptions

Ƭ **ImportCsvOptions**: `Object`

**`property`** {GC.Spread.Sheets.FileType} fileType - The file type.

**`property`** {string} [encoding] - The csv encoding type, the default encoding type is 'UTF-8'.

**`property`** {string} [rowDelimiter] - The row delimiter that is appended to the end of the row, the default row delimiter is '\r\n'.

**`property`** {string} [columnDelimiter] - The column delimiter that is appended to the end of the column, the default column delimiter is ','.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `columnDelimiter?` | `string` |
| `encoding?` | `string` |
| `rowDelimiter?` | `string` |

___

### <a id="importoptions" name="importoptions"></a> ImportOptions

Ƭ **ImportOptions**: [`FileOptions`](GC.Spread.Sheets#fileoptions) & [`ImportCsvOptions`](GC.Spread.Sheets#importcsvoptions) \| [`ImportSSJsonOptions`](GC.Spread.Sheets#importssjsonoptions) \| [`ImportXlsxOptions`](GC.Spread.Sheets#importxlsxoptions)

___

### <a id="importssjsonoptions" name="importssjsonoptions"></a> ImportSSJsonOptions

Ƭ **ImportSSJsonOptions**: `Object`

**`property`** {GC.Spread.Sheets.FileType} fileType - The file type.

**`property`** {boolean} [includeStyles] - Whether to include the style when converting json to the workbook, default true.

**`property`** {boolean} [includeFormulas] - Whether to include the formula when converting json to the workbook, default true.

**`property`** {boolean} [frozenColumnsAsRowHeaders] - Whether to treat the frozen columns as row headers when converting json to the workbook, default false.

**`property`** {boolean} [frozenRowsAsColumnHeaders] - Whether to treat the frozen rows as column headers when converting json to the workbook, default false.

**`property`** {boolean} [fullRecalc] - Whether to do full recalculation after loading the json data, default true.

**`property`** {boolean | object} [incrementalLoad] - Whether to use the incremental loading or the callbacks of incremental loading when converting json to the workbook, default false.

**`param`** The callback when of the incremental loading progress.

**`param`** The callback when of the incremental loading finished.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `frozenColumnsAsRowHeaders?` | `boolean` |
| `frozenRowsAsColumnHeaders?` | `boolean` |
| `fullRecalc?` | `boolean` |
| `includeFormulas?` | `boolean` |
| `includeStyles?` | `boolean` |
| `incrementalLoad?` | `any` |

___

### <a id="importxlsxoptions" name="importxlsxoptions"></a> ImportXlsxOptions

Ƭ **ImportXlsxOptions**: `Object`

**`property`** {GC.Spread.Sheets.FileType} fileType - The file type.

**`property`** {boolean} [includeStyles] - Whether to include the style when loading, default true.

**`property`** {boolean} [includeFormulas] - Whether to include the formula when loading, default true.

**`property`** {boolean} [frozenColumnsAsRowHeaders] - Whether to treat the frozen columns as row headers when loading, default false.

**`property`** {boolean} [frozenRowsAsColumnHeaders] - Whether to treat the frozen rows as column headers when loading, default false.

**`property`** {boolean} [fullRecalc] - Whether to calculate after loading the json data, false by default.

**`property`** {boolean} [dynamicReferences] - Whether to calculate functions with dynamic reference, default true.

**`property`** {boolean} [calcOnDemand] - Whether to calculate formulas only when they are demanded, default false.

**`property`** {boolean} [includeUnusedStyles] - Whether to include the unused name style when converting excel xml to the json, default true.

**`property`** {string} [password] - The password to open the workbook.

**`property`** {GC.Spread.Sheets.OpenMode} [openMode] - The open mode of normal, lazy and incremental. By default is normal.

**`property`** {GC.Spread.Sheets.ProgressFunctionType} [progress] - The progress callback function for each open mode.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `calcOnDemand?` | `boolean` |
| `dynamicReferences?` | `boolean` |
| `frozenColumnsAsRowHeaders?` | `boolean` |
| `frozenRowsAsColumnHeaders?` | `boolean` |
| `fullRecalc?` | `boolean` |
| `includeFormulas?` | `boolean` |
| `includeStyles?` | `boolean` |
| `includeUnusedStyles?` | `boolean` |
| `openMode?` | [`OpenMode`](../enums/GC.Spread.Sheets.OpenMode) |
| `password?` | `string` |
| `progress?` | [`ProgressFunctionType`](GC.Spread.Sheets#progressfunctiontype) |

___

### <a id="openoptions" name="openoptions"></a> OpenOptions

Ƭ **OpenOptions**: `Object`

**`property`** {boolean} [includeStyles] - Whether to include the style when loading, default true.

**`property`** {boolean} [includeFormulas] - Whether to include the formula when loading, default true.

**`property`** {boolean} [fullRecalc] - Whether to calculate after loading the json data, false by default.

**`property`** {boolean} [dynamicReferences] - Whether to calculate functions with dynamic reference, default true.

**`property`** {boolean} [calcOnDemand] - Whether to calculate formulas only when they are demanded, default false.

**`property`** {boolean} [includeUnusedStyles] - Whether to include the unused name style when converting excel xml to the json, default true.

**`property`** {GC.Spread.Sheets.OpenMode} [openMode] - The open mode of normal, lazy and incremental. By default is normal.

**`property`** {GC.Spread.Sheets.ProgressFunctionType} [progress] - The progress callback function for each open mode.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `calcOnDemand?` | `boolean` |
| `dynamicReferences?` | `boolean` |
| `fullRecalc?` | `boolean` |
| `includeFormulas?` | `boolean` |
| `includeStyles?` | `boolean` |
| `includeUnusedStyles?` | `boolean` |
| `openMode?` | [`OpenMode`](../enums/GC.Spread.Sheets.OpenMode) |
| `progress?` | [`ProgressFunctionType`](GC.Spread.Sheets#progressfunctiontype) |

___

### <a id="partialvalues" name="partialvalues"></a> PartialValues

Ƭ **PartialValues**: `Object`

**`property`** {GC.Spread.Sheets.CellValue} row - A key-value collection, which key is a row number, and value is type of GC.Spread.Sheets.CellValue.

#### Index signature

▪ [row: `number`]: [`CellValue`](GC.Spread.Sheets#cellvalue)

___

### <a id="progressargs" name="progressargs"></a> ProgressArgs

Ƭ **ProgressArgs**: `Object`

**`property`** {string} sheetName - the current loading sheet's name.

**`property`** {string} step - the current loading step.

**`property`** {number} progress - the current loading progress, from 0 ~ 1.

#### Type declaration

| Name | Type | Description |
| :------ | :------ | :------ |
| `progress` | `number` | the current loading progress, from 0 ~ 1. |
| `sheetName?` | `string` | the current loading sheet's name. |
| `step` | `string` | the current loading step. |

___

### <a id="progressfunctiontype" name="progressfunctiontype"></a> ProgressFunctionType

Ƭ **ProgressFunctionType**: (`progressArgs`: [`ProgressArgs`](GC.Spread.Sheets#progressargs)) => `void`

#### Type declaration

▸ (`progressArgs`): `void`

**`description`** The callback when of the incremental loading progress.

##### Parameters

| Name | Type | Description |
| :------ | :------ | :------ |
| `progressArgs` | [`ProgressArgs`](GC.Spread.Sheets#progressargs) | the progress arguments. |

##### Returns

`void`

___

### <a id="saveoptions" name="saveoptions"></a> SaveOptions

Ƭ **SaveOptions**: `Object`

**`property`** {boolean} [includeBindingSource] - Whether to include the binding source when do save, default false.

**`property`** {boolean} [includeStyles] - Whether to include the style when do save, default true.

**`property`** {boolean} [includeFormulas] - Whether to include the formula when do save, default true.

**`property`** {boolean} [saveAsView] - Whether to apply the format string to exporting value when do save, default false.

**`property`** {boolean} [includeAutoMergedCells] - Whether to include the automatically merged cells when do save, default false.

**`property`** {boolean} [includeCalcModelCache] - Whether to include the extra data of calculation. Can be faster when open the file with those data, default false.

**`property`** {boolean} [includeUnusedNames] - Whether to include the unused custom name when do save, default true.

**`property`** {boolean} [includeEmptyRegionCells] - Whether to include any empty cells(cells with no data or only style) outside the used data range, default true.

#### Type declaration

| Name | Type |
| :------ | :------ |
| `includeAutoMergedCells?` | `boolean` |
| `includeBindingSource?` | `boolean` |
| `includeCalcModelCache?` | `boolean` |
| `includeEmptyRegionCells?` | `boolean` |
| `includeFormulas?` | `boolean` |
| `includeStyles?` | `boolean` |
| `includeUnusedNames?` | `boolean` |
| `saveAsView?` | `boolean` |

## Variables

### <a id="licensekey" name="licensekey"></a> LicenseKey

• **LicenseKey**: `string`

Represents the license key for evaluation version and production version.

## Functions

### <a id="findcontrol" name="findcontrol"></a> findControl

▸ **findControl**(`host`): [`Workbook`](../classes/GC.Spread.Sheets.Workbook)

Gets the Workbook instance by the host element.

#### Parameters

| Name | Type | Description |
| :------ | :------ | :------ |
| `host` | `string` \| `HTMLElement` | The host element or the host element id. |

#### Returns

[`Workbook`](../classes/GC.Spread.Sheets.Workbook)

The Workbook instance.

___

### <a id="gettypefromstring" name="gettypefromstring"></a> getTypeFromString

▸ **getTypeFromString**(`typeString`): `any`

Gets the type from the type string. This method is used for supporting the serialization of the custom object.

#### Parameters

| Name | Type | Description |
| :------ | :------ | :------ |
| `typeString` | `string` | The type string. |

#### Returns

`any`

The type.