- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
-
FarPoint.Win.Spread Assembly
-
FarPoint.Win.Spread
-
Classes
- Action
- ActionMap
- ActiveSheetChangingEventArgs
- AdvanceEventArgs
- AdvancedSearchDialog
- AlternatingRow
- AlternatingRows
- AnimatedDefaultFocusIndicatorRenderer
- AnnotationModeEventArgs
- Appearance
- AppearanceActionBase
- AppearanceStyleCollection
- AppearanceStyleInfo
- ApplyEventArgs
- AutoFilteredColumnEventArgs
- AutoFilteringColumnEventArgs
- AutoSortedColumnEventArgs
- AutoSortingColumnEventArgs
- AverageConditionalFormattingRule
- BaseDataValidator
- BaseFilterItem
- BaseSparkline
- BeforeRightClickEventArgs
- BeforeSettingPropertyValueEventArgs
- BeforeShowContextMenuEventArgs
- BestFitColumnRule
- BetweenValuesConditionalFormattingRule
- BlankConditionalFormattingRule
- CalculateExceptionEventArgs
- Cell
- CellClickEventArgs
- CellErrorTextChangedEventArgs
- CellFooter
- CellInfo
- CellInfoRange
- CellPadding
- CellStyleNotify
- CellTouchStrip
- CellValidateInfoNeededEventArgs
- Cells
- CellsEditorForm
- ChangeEventArgs
- CharFormatValidator
- ChartTouchStrip
- ChildControlEventArgs
- ChildViewCreatedEventArgs
- ChildWorkbookCreatedEventArgs
- CircularCellChangedEventArgs
- CircularFormulaEventArgs
- CircularFormulaEventInfo
- ClipboardPastedEventArgs
- ClipboardPastingEventArgs
- ColorFilterItem
- Column
- ColumnClipInfo
- ColumnClipInfoRange
- ColumnFooter
- ColumnHeader
- ColumnSparklineRenderer
- ColumnTouchStrip
- ColumnViewportWidthChangedEventArgs
- ColumnWidthChangeExtents
- ColumnWidthChangedEventArgs
- ColumnWidthChangingEventArgs
- Columns
- Columns.DefaultColumn
- CombinedStyleInfo
- CompareCellValidator
- CompareStringValidator
- CompareValueBaseValidator
- CompareValueValidator
- ComplexSortInfo
- ConditionalFormat
- ConditionalFormatting
- ConditionalFormattingChangedEventArgs
- ConditionalFormattingColorValue
- ConditionalFormattingColorValueCollection
- ConditionalFormattingIconRuleSet
- ConditionalFormattingIconSetIndex
- ConditionalFormattingIconValue
- ConditionalFormattingModel
- ConditionalFormattingModelEventArgs
- ConditionalFormattingRule
- ConditionalFormattingRulePropertyChangedEventArgs
- ConditionalFormattingValue
- ConditionalFormattingValueCollection
- ConditionalStyleInfo
- ConditionalStyleItem
- ConditionalStyleItemCollection
- CustomFillSeriesList
- CustomFilterItem
- CustomFocusIndicatorRenderer
- CustomIconContainer
- CustomImageInfo
- CustomNameChangedEventArgs
- DataAddNewException
- DataColumnConfigureEventArgs
- DataFieldConverter
- DataValidationManager
- DatabarConditionalFormattingRule
- DefaultErrorIconRenderer
- DefaultFilterItem
- DefaultFocusIndicatorRenderer
- DefaultGroupFooter
- DefaultGroupFooterCollection
- DefaultNoteIndicatorRenderer
- DefaultRangeGroupModel
- DefaultRowFilter
- DefaultScrollBarRenderer
- DefaultSelectionRenderer
- DefaultSkins
- DefaultSparklineContainer
- DefaultSpreadSkins
- DefaultStyleCollection
- DelegateResolveEventArgs
- DialogCharEventArgs
- DialogKeyEventArgs
- DocumentPropertiesForm
- DragDropBlockCompletedEventArgs
- DragDropBlockEventArgs
- DragFillBlockCompletedEventArgs
- DragFillBlockEventArgs
- DragMoveCompletedEventArgs
- DragMoveCompletingEventArgs
- DragMoveEventArgs
- DropDownControl
- DynamicFilterItem
- DynamicStyleInfo
- DynamicStyleInfoContext
- EditErrorEventArgs
- EditModeStartingEventArgs
- EditingFocusIndicatorRenderer
- EditorNotifyEventArgs
- EncodingValidator
- EnhancedFocusIndicatorRenderer
- EnhancedInterfaceRenderer
- EnhancedScrollBarRenderer
- EnterCellEventArgs
- ErrorConditionalFormattingRule
- ErrorEventArgs
- EventNameConverter
- ExcelBaseSparkLineRenderer
- ExcelSparkline
- ExcelSparklineGroup
- ExcelSparklineSetting
- ExcludeListValidator
- ExpandEventArgs
- ExtraRendererSettings
- FilterBar
- FilterBarEventArgs
- FilterBarHitTestInformation
- FilterColumnDefinition
- FilterColumnDefinitionCollection
- FilterCondition
- FilterItemCollection
- FilterItemValue
- FilterItemValueCollection
- FlatFocusIndicatorRenderer
- FlatInterfaceRenderer
- FlatScrollBarRenderer
- FlatSelectionRenderer
- FocusProcess
- FormatCells
- FormulaConditionalFormattingRule
- FormulaTextBox
- FpBaseStatusBarElement
- FpHorizontalScrollBar
- FpScrollBar
- FpScrollBarButton
- FpScrollBarButtonBackwardHome
- FpScrollBarButtonBackwardLine
- FpScrollBarButtonBackwardPage
- FpScrollBarButtonClickEventArgs
- FpScrollBarButtonCollection
- FpScrollBarButtonForwardEnd
- FpScrollBarButtonForwardLine
- FpScrollBarButtonForwardPage
- FpScrollBarComboThumb
- FpScrollBarGripper
- FpScrollBarThumb
- FpScrollBarTrack
- FpScrollBarTrackBackward
- FpScrollBarTrackForward
- FpSpread
- FpStatusBarAverageElement
- FpStatusBarCountElement
- FpStatusBarElementCollection
- FpStatusBarMaxElement
- FpStatusBarMinElement
- FpStatusBarNumericalCountElement
- FpStatusBarRangeStatusElement
- FpStatusBarRangeStatusFormatElement
- FpStatusBarSumElement
- FpStatusBarTextElement
- FpVerticalScrollBar
- GetCustomIconEventArgs
- GradientInterfaceRenderer
- GradientSelectionRenderer
- GridLine
- GroupBarInfo
- GroupInfo
- GroupInfoCollection
- GroupingEventArgs
- HeaderEditForm
- HeaderHitTestInformation
- HideRowFilter
- HighlightConditionalFormattingRule
- HighlightConditionalFormattingStyle
- HitTestInformation
- HyperLinkClickedEventArgs
- HyperlinkForm
- IconFilterItem
- IconNotify
- IconSetConditionalFormattingRule
- ImageFocusIndicatorRenderer
- IncludeListValidator
- InputMap
- InputScreenTipDialog
- InputTextDialog
- InvalidFileFormatException
- ItemEventArgs
- ItemTrackedEventArgs
- KeystrokeFactory
- LandscapeRule
- LeaveCellEventArgs
- LeftChangeEventArgs
- LineNotify
- LineSparklineRenderer
- MarqueeFocusIndicatorRenderer
- MessageBoxNotify
- ModelessForm
- MultiValuesFilterItem
- NameBox
- NamedAppearanceStyleInfo
- NamedObjectCollection<T>
- NamedStyle
- NamedStyleCollection
- NamedStyleCollectionEventArgs
- NoteEventArgs
- OwnerPrintInfo
- PaintGrayAreaEventArgs
- PaintGroupBarBackgroundEventArgs
- PaintTabStripButtonEventArgs
- PaintTabStripEventArgs
- PaintTabStripTabEventArgs
- PairChar
- PairCharValidator
- ParentStyleNameConverter
- PrePaintConditionalFormattingRule
- PrePaintResult
- PrePaintTextConditionalFormattingRule
- PrePaintTextResult
- PreviewRowFetchEventArgs
- PreviewRowInfo
- PrintAbortEventArgs
- PrintBackgroundEventArgs
- PrintCancelledEventArgs
- PrintDocumentEventArgs
- PrintHeaderFooterAreaEventArgs
- PrintInfo
- PrintMargin
- PrintMessageBoxEventArgs
- PrintPreviewShowingEventArgs
- PropertyTrackChangedEventArgs
- QueryAccessibleObjectValueEventArgs
- QueryValueEventArgs
- RangeElement<T>
- RangeGroupHitTestInformation
- RangeGroupInfo
- RangeGroupInfoEventArgs
- RangeGroupModelEventArgs
- RangeGroupStateChangedEventArgs
- RangeGroupStateChangingEventArgs
- RangeValidator
- RecentItemsEventArgs<T>
- RegularExpressionValidator
- ReloadSheetCellRangeFormulaEventArgs
- RequiredFieldValidator
- RequiredTypeValidator
- ResolveActionEventArgs
- ResolveCustomControlEventArgs
- Row
- RowClipInfo
- RowClipInfoRange
- RowErrorTextChangedEventArgs
- RowHeader
- RowHeightChangeExtents
- RowHeightChangedEventArgs
- RowHeightChangingEventArgs
- RowTouchStrip
- RowViewportHeightChangedEventArgs
- Rows
- Rows.DefaultRow
- SaveNamedStyleCollection
- ScaleRule
- ScrollTipFetchEventArgs
- ScrollingContentInfo
- SearchDialog
- SelectionChangedEventArgs
- SelectionChangingEventArgs
- ShapeTouchStrip
- SheetCorner
- SheetDragMovedEventArgs
- SheetDragMovingEventArgs
- SheetSkin
- SheetSkinsForm
- SheetStyleProperty
- SheetTab
- SheetTabClickEventArgs
- SheetTabDoubleClickEventArgs
-
SheetView
- Constructors
- Fields
- Properties
-
Methods
- AddChart
- AddColumnFooterSpanCell
- AddColumnHeaderSpanCell
- AddColumns
- AddControl
- AddCustomName
- AddRangeGroup
- AddRowHeaderSpanCell
- AddRowToDataSource
- AddRows
- AddSelection
- AddShape
- AddSpanCell
- AddSparkline
- AddSquareSparkline
- AddTable
- AddUnboundRows
- AddValidators
- AsWorksheet
- AutoFilterColumn
- AutoFilterReset
- AutoSortColumn
- BindDataColumn
- ClearColumnFooterSpanCells
- ClearColumnHeaderSpanCells
- ClearConditionalFormating
- ClearConditionalFormatings
- ClearControls
- ClearCustomFunctions
- ClearCustomNames
- ClearRange
- ClearRangeGroup
- ClearRowFilter
- ClearRowHeaderSpanCells
- ClearSelection
- ClearShapes
- ClearSpanCells
- ClearSparklineGroupsInRange
- ClearSparklines
- ClearValidators
- ClipboardCopy
- ClipboardCopyShape
- ClipboardCut
- ClipboardCutShape
- ClipboardPaste
- ClipboardPasteShape
- Clone
- ConvertTableToRange
- CopyRange
- DisableProtect
- Dispose
- EvaluateExpression
- ExpandRangeGroup
- ExpandRow
- FillRange
- FindChildView
- FirePropertyChanged
- GetArray
- GetCellErrorText
- GetCellFromTag
- GetCellReference
- GetCellType
- GetChildRelation
- GetChildSheets
- GetChildView
- GetChildVisible
- GetClip
- GetClipDataObject
- GetClipValue
- GetColumnAllowAutoSort
- GetColumnAllowFilter
- GetColumnAutoFilterIndex
- GetColumnAutoSortIndex
- GetColumnAutoText
- GetColumnFooterText
- GetColumnFromTag
- GetColumnHeaderSpanCell
- GetColumnLabel
- GetColumnMerge
- GetColumnPageBreak
- GetColumnShowSortIndicator
- GetColumnSizeable
- GetColumnSortIndicator
- GetColumnVisible
- GetColumnVisibleCount
- GetColumnWidth
- GetConditionalFormatting
- GetControl
- GetControlContainer
- GetCustomFunctionEnumerator
- GetCustomName
- GetCustomNameComment
- GetCustomNameEnumerator
- GetDataView
- GetDropDownFilterItems
- GetEditor
- GetFilterBarCellType
- GetFormula
- GetLastNonEmptyColumn
- GetLastNonEmptyRow
- GetModelColumnFromViewColumn
- GetModelRowFromViewRow
- GetNote
- GetNoteBounds
- GetObjectData
- GetPreferredCellSize
- GetPreferredColumnWidth
- GetPreferredPrintColumnWidth
- GetPreferredPrintRowHeight
- GetPreferredRowHeight
- GetRangeGroupInfo
- GetRangeGroupLevels
- GetRenderer
- GetRootSheet
- GetRowAutoText
- GetRowErrorText
- GetRowExpandable
- GetRowFromTag
- GetRowHeaderSpanCell
- GetRowHeight
- GetRowLabel
- GetRowMerge
- GetRowPageBreak
- GetRowSizeable
- GetRowVisible
- GetRowVisibleCount
- GetSelection
- GetSelections
- GetShape
- GetSpanCell
- GetSparkline
- GetStickyNoteStyleInfo
- GetStyleInfo
- GetTable
- GetTableEnumerator
- GetTag
- GetText
- GetUnboundValue
- GetValidConditionalFormat
- GetValidators
- GetValue
- GetViewColumnFromModelColumn
- GetViewRowFromModelRow
- GroupSparkline
- InitPropArray
- IsAnyCellInColumnSelected
- IsAnyCellInRowSelected
- IsColumnBound
- IsLockObject
- IsRowBound
- IsRowExpanded
- IsSelected
- JoinShapes
- LoadFormulas
- LoadTextFile
- LoadTextFileRange
- ModifyCustomName
- MoveColumn
- MoveRange
- MoveRow
- OnAddColumnFooterRows
- OnAddColumnHeaderRows
- OnAddColumns
- OnAddRowHeaderColumns
- OnAddRows
- OnCellChanged
- OnCopyCells
- OnCopyColumns
- OnCopyRows
- OnDataModelChanged
- OnDisposing
- OnMoveCells
- OnMoveColumns
- OnMoveRows
- OnNoteCreated
- OnNoteMoved
- OnNoteSized
- OnRemoveColumnFooterRows
- OnRemoveColumnHeaderRows
- OnRemoveColumns
- OnRemoveRowHeaderColumns
- OnRemoveRows
- OnSheetColumnAxisModelChanged
- OnSheetRangeGroupModelChanged
- OnSheetRowAxisModelChanged
- OnSpanModelChanged
- OnStickyNoteCreated
- OnStickyNoteMoved
- OnStickyNoteSized
- OnStyleModelChanged
- OnSwapCells
- OnSwapColumns
- OnSwapRows
- Open
- OpenExcel
- OpenSpreadFile
- RaiseCellChanged
- RaisePropertyChanged
- Recalculate
- RecalculateAll
- RemoveColumnFooterSpanCell
- RemoveColumnHeaderSpanCell
- RemoveColumns
- RemoveControl
- RemoveCustomFunction
- RemoveCustomName
- RemoveRangeGroup
- RemoveRowHeaderSpanCell
- RemoveRows
- RemoveSelection
- RemoveShape
- RemoveSpanCell
- RemoveTable
- Reset
- RestoreProtect
- ResumeAutoUpdateChartData
- ResumeFormulaParsing
- Save
- SaveHtml
- SaveHtmlRange
- SaveImage
- SaveTextFile
- SaveTextFileRange
- SaveXml
- SetActiveCell
- SetArray
- SetCellErrorText
- SetChildVisible
- SetClip
- SetClipSpecial
- SetClipValue
- SetColumnAllowAutoSort
- SetColumnAllowFilter
- SetColumnAutoFilterIndex
- SetColumnAutoSortIndex
- SetColumnLabel
- SetColumnMerge
- SetColumnPageBreak
- SetColumnShowSortIndicator
- SetColumnSizeable
- SetColumnSortIndicator
- SetColumnVisible
- SetColumnWidth
- SetConditionalFormatting
- SetCustomNameComment
- SetErrorValue
- SetFilteredColumn
- SetFormula
- SetInsideBorder
- SetModelColumnForViewColumn
- SetModelRowForViewRow
- SetMultipleColumnWidths
- SetMultipleRowHeights
- SetNote
- SetNoteBounds
- SetOutlineBorder
- SetRowErrorText
- SetRowExpandable
- SetRowHeight
- SetRowLabel
- SetRowMerge
- SetRowPageBreak
- SetRowSizeable
- SetRowVisible
- SetStickyNoteStyleInfo
- SetStyleInfo
- SetTag
- SetText
- SetValue
- ShouldSerializeAlternatingRows
- ShouldSerializeBackgroundImage
- ShouldSerializeCells
- ShouldSerializeColumnFooterSheetCornerHorizontalGridLine
- ShouldSerializeColumnFooterSheetCornerStyle
- ShouldSerializeColumnFooterSheetCornerVerticalGridLine
- ShouldSerializeColumns
- ShouldSerializeDefaultStyle
- ShouldSerializeFilterBarHeaderStyle
- ShouldSerializeGrayAreaBackColor
- ShouldSerializeHorizontalGridLine
- ShouldSerializeIsBackgroundImageTiled
- ShouldSerializeLockFont
- ShouldSerializeModels
- ShouldSerializeNullBackColor
- ShouldSerializeNullFont
- ShouldSerializeNullForeColor
- ShouldSerializePrintInfo
- ShouldSerializeRows
- ShouldSerializeSaveNamedStyles
- ShouldSerializeSelectionBackColor
- ShouldSerializeSelectionFont
- ShouldSerializeSelectionForeColor
- ShouldSerializeSheetCornerHorizontalGridLine
- ShouldSerializeSheetCornerStyle
- ShouldSerializeSheetCornerVerticalGridLine
- ShouldSerializeVerticalGridLine
- ShouldSerializeZoomFactor
- ShowNotes
- SortColumns
- SortRange
- SortRows
- SuspendAutoUpdateChartData
- SuspendFormulaParsing
- SwapRange
- UngroupSparkline
- UpdateNotes
- UpdatePropArray
- Validate
- Events
- SheetView.DocumentModels
- SheetView.MultipleColumnMovingException
- SheetView.MultipleRowMovingException
- SheetView.SaveAutoSortColumns
- SheetViewCollection
- SheetViewEventArgs
- SheetViewPropertyChangeEventArgs
- SlicerInsertForm
- SlicerSettingsForm
- SmartPaperRule
- SmartPrintRule
- SmartPrintRulesCollection
- SolidFocusIndicatorRenderer
- SortArgs
- SortInfo
- SortedEventArgs
- SortingEventArgs
- SoundNotify
- Sparkline
- SparklineInfo
- SparklineModelUpdateEventArgs
- SpreadActions
- SpreadContextMenuStrip
- SpreadFontStyle
- SpreadHScrollBar
- SpreadSkin
- SpreadSkinsForm
- SpreadSparklineRenderes
- SpreadTouchStrip
- SpreadVScrollBar
- SpreadView
- StatusBarDefaultSkin
- StatusBarElementChangeArgs
- StatusBarSkin
- StickyNoteEventArgs
- StyleInfo
- StyleNameConverter
- StyleRowFilter
- SubEditorClosedEventArgs
- SubEditorOpeningEventArgs
- SurrogateCharValidator
- TabStrip
- TabStripButtonClickEventArgs
- TabStripHitTestInformation
- TableBorder
- TableElementStyle
- TablePropertyChangedEventArgs
- TablePropertyChangingEventArgs
- TableStyle
- TableStyleCollection
- TableStyleCollectionChangedEventArgs
- TableUtils
- TableView
- TableViewClipboardInfo
- TableViewColumn
- TableViewColumnCollection
- TextConditionalFormattingRule
- TextLengthValidator
- TextTipFetchEventArgs
- ThreeColorScaleConditionalFormattingRule
- ThreeStateIconNotify
- TimePeriodConditionalFormattingRule
- TipAppearance
- TipNotify
- TitleInfo
- TitlebarHitTestInformation
- Top10FilterItem
- TopChangeEventArgs
- TopRankedValuesConditionalFormattingRule
- TouchStripButton
- TouchStripOpeningEventArgs
- TriangleNoteIndicatorRenderer
- TwoColorScaleConditionalFormattingRule
- UnaryComparisonConditionalFormattingRule
- UniqueOrDuplicatedConditionalFormattingRule
- UserFormulaEnteredEventArgs
- UserSpecifiedFilterItem
- ValidateActionBase
- ValidateActionCollection
- ValidateActionContext
- ValueProcess
- ViewportHitTestInformation
- WinLossSparklineRenderer
- ZoomEventArgs
- ZoomSliderStatusBarElement
- ZoomStatusBarElement
- Structs
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Win.Spread.CellType
- FarPoint.Win.Spread.Chart
- FarPoint.Win.Spread.Data
- FarPoint.Win.Spread.Dialogs
- FarPoint.Win.Spread.DrawingSpace
- FarPoint.Win.Spread.Model
- FarPoint.Win.Spread.UndoRedo
- FarPoint.Win.Spread.Visualization
-
FarPoint.Win.Spread
- GrapeCity.CalcEngine Assembly
- GrapeCity.Spreadsheet Assembly
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
FarPoint.Win.Spread.SheetView.SetValue
SetValue Method
SetValue(int, int, object)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, object value)Public Sub SetValue(row As Integer, column As Integer, value As Object)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| object | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, bool)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, bool value)Public Sub SetValue(row As Integer, column As Integer, value As Boolean)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| bool | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, DateTime)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, DateTime value)Public Sub SetValue(row As Integer, column As Integer, value As Date)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| DateTime | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, double)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, double value)Public Sub SetValue(row As Integer, column As Integer, value As Double)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| double | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, int)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, int value)Public Sub SetValue(row As Integer, column As Integer, value As Integer)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| int | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, char)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, char value)Public Sub SetValue(row As Integer, column As Integer, value As Char)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| char | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, sbyte)
Sets the value for the specified cell on this sheet.
Declaration
[CLSCompliant(false)]
public void SetValue(int row, int column, sbyte value)<CLSCompliant(False)>
Public Sub SetValue(row As Integer, column As Integer, value As SByte)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| sbyte | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, byte)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, byte value)Public Sub SetValue(row As Integer, column As Integer, value As Byte)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| byte | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, short)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, short value)Public Sub SetValue(row As Integer, column As Integer, value As Short)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| short | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, ushort)
Sets the value for the specified cell on this sheet.
Declaration
[CLSCompliant(false)]
public void SetValue(int row, int column, ushort value)<CLSCompliant(False)>
Public Sub SetValue(row As Integer, column As Integer, value As UShort)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| ushort | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, uint)
Sets the value for the specified cell on this sheet.
Declaration
[CLSCompliant(false)]
public void SetValue(int row, int column, uint value)<CLSCompliant(False)>
Public Sub SetValue(row As Integer, column As Integer, value As UInteger)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| uint | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, long)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, long value)Public Sub SetValue(row As Integer, column As Integer, value As Long)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| long | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, ulong)
Sets the value for the specified cell on this sheet.
Declaration
[CLSCompliant(false)]
public void SetValue(int row, int column, ulong value)<CLSCompliant(False)>
Public Sub SetValue(row As Integer, column As Integer, value As ULong)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| ulong | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, float)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, float value)Public Sub SetValue(row As Integer, column As Integer, value As Single)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| float | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, decimal)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, decimal value)Public Sub SetValue(row As Integer, column As Integer, value As Decimal)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| decimal | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, string)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, string value)Public Sub SetValue(row As Integer, column As Integer, value As String)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| string | value | Value to set for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
SetValue(int, int, object, bool)
Sets the value for the specified cell on this sheet.
Declaration
public void SetValue(int row, int column, object value, bool validate)Public Sub SetValue(row As Integer, column As Integer, value As Object, validate As Boolean)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| object | value | Value to set for the specified cell |
| bool | validate | Perform value validation |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
- SetValue Method
- SetValue(int, int, object)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, bool)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, DateTime)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, double)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, int)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, char)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, sbyte)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, byte)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, short)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, ushort)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, uint)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, long)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, ulong)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, float)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, decimal)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, string)
- Declaration
- Parameters
- Exceptions
- SetValue(int, int, object, bool)
- Declaration
- Parameters
- Exceptions