| Name | Description |
![Public Method](dotnetimages/publicMethod.gif) | AddColumn | Overloaded. Adds a column to the data model after the last column. |
![Public Method](dotnetimages/publicMethod.gif) | AddColumns | Adds one or more columns to the data model at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | AddCustomFunction | Adds a new user-defined custom function to the model for use in formulas. |
![Public Method](dotnetimages/publicMethod.gif) | AddCustomName | Overloaded. Adds a named expression to the model for use in formulas. |
![Public Method](dotnetimages/publicMethod.gif) | AddRow | Overloaded. Adds a row to the data model at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | AddRows | Adds rows to the data model at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | AddRowToDataSource | Adds the unbound row to the data source. |
![Public Method](dotnetimages/publicMethod.gif) | AddUnboundRows | Adds unbound rows to the data model. |
![Public Method](dotnetimages/publicMethod.gif) | Clear | Removes all the data and formulas from the specified range of cells. |
![Public Method](dotnetimages/publicMethod.gif) | ClearCustomFunctions | Removes all user-defined custom functions from the model. |
![Public Method](dotnetimages/publicMethod.gif) | ClearCustomNames | Removes all named expressions from the model. |
![Public Method](dotnetimages/publicMethod.gif) | ClearData | Removes all the data from the specified range of cells. |
![Public Method](dotnetimages/publicMethod.gif) | ClearFormulas | Removes all of the formulas from the specified range of cells. |
![Public Method](dotnetimages/publicMethod.gif) | CompareExpression | Gets whether two expressions are equal. |
![Public Method](dotnetimages/publicMethod.gif) | Copy | Copies the data from a range of cells to a specified range of cells. |
![Public Method](dotnetimages/publicMethod.gif) | Deserialize | Loads the object from XML. |
![Public Method](dotnetimages/publicMethod.gif) | EvaluateExpression | Evaluates the expression in the cell at the specified row and column and returns the resulting object. |
![Public Method](dotnetimages/publicMethod.gif) | GetAggregationResult | Calculates the value based on the aggregation type and formats the value with the aggregation format. |
![Public Method](dotnetimages/publicMethod.gif) | GetAggregationType | Gets the AggregationType, as a string value, at the specified column. |
![Public Method](dotnetimages/publicMethod.gif) | GetArray | Overloaded. Gets an object array from a specified range of cells. |
![Public Method](dotnetimages/publicMethod.gif) | GetChildDataModel | Gets the data model (ISheetDataModel object) for the specified row and data relation. |
![Public Method](dotnetimages/publicMethod.gif) | GetChildRelation | Gets the name of the child data relation at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | GetColumnIndex | Gets the index of the column specified by name. |
![Public Method](dotnetimages/publicMethod.gif) | GetCustomFunction | Gets a user-defined custom function from the model. |
![Public Method](dotnetimages/publicMethod.gif) | GetCustomFunctionEnumerator | Gets an IEnumerator that enumerates through the names of the custom functions in the model. |
![Public Method](dotnetimages/publicMethod.gif) | GetCustomName | Overloaded. Gets a named expression from the model with the specified base index for relative cell references. |
![Public Method](dotnetimages/publicMethod.gif) | GetCustomNameEnumerator | Gets an IEnumerator that enumerates through the names of the named expressions in the model. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataColumnCaption | Gets the column caption at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataColumnFromModelColumn | Gets the data source column index for the specified column in the model. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataColumnName | Gets the column name at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataColumnType | Gets the column data type at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataRow | Gets the view of a specified row of data. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataRowFromModelRow | Gets the data source row index for the specified row in the model. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataTable | Gets the data table associated with this model. |
![Public Method](dotnetimages/publicMethod.gif) | GetDataView | Overloaded. Gets the DataView object associated with this model. |
![Public Method](dotnetimages/publicMethod.gif) | GetExpression | Gets the formula, as an expression value, for the cell of the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | GetFormula | Gets the formula, as a string value, for the cell of the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | GetItem | Returns the IEditableObject from a row that is data bound to a DataView or ListSource. |
![Public Method](dotnetimages/publicMethod.gif) | GetKey | Gets a key for the specified row or column. |
![Public Method](dotnetimages/publicMethod.gif) | GetModelColumnFromDataColumn | Gets the column in the model for the specified data source column. |
![Public Method](dotnetimages/publicMethod.gif) | GetModelRowFromDataRow | Gets the row in the model for the specified data source row. |
![Public Method](dotnetimages/publicMethod.gif) | GetNonEmptyNotesColumnCount | Gets the number of columns that contain notes. |
![Public Method](dotnetimages/publicMethod.gif) | GetNonEmptyNotesRowCount | Gets the number of rows that contain notes. |
![Public Method](dotnetimages/publicMethod.gif) | GetNote | Overridden. Gets a user-defined note value for the cell of the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | GetTag | Overridden. Gets an application-defined tag value for the cell of the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | GetUnboundValue | Gets the unbound value for the cell for the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | GetValue | Overridden. Gets the value of the cell for the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | GoalSeek | Attempts to find a value for one cell that produces the desired formula result in another cell. |
![Public Method](dotnetimages/publicMethod.gif) | IsColumnBound | Determines whether the specified column is bound to a data source column. |
![Public Method](dotnetimages/publicMethod.gif) | IsEditable | Overridden. Determines whether the value in the cell of the specified row and column can be edited. |
![Public Method](dotnetimages/publicMethod.gif) | IsEmpty | Overridden. Determines whether the data model is empty. |
![Public Method](dotnetimages/publicMethod.gif) | IsRowBound | Determines whether the specified row is bound to a data source row. |
![Public Method](dotnetimages/publicMethod.gif) | IsRowUsed | Overridden. Determines whether the specified row is not empty. |
![Public Method](dotnetimages/publicMethod.gif) | LoadFormulas | Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized. |
![Public Method](dotnetimages/publicMethod.gif) | Move | Moves the data from a range of cells to the specified location. |
![Public Method](dotnetimages/publicMethod.gif) | NextNonEmptyColumnInRow | Overridden. Gets the index of the next column in a specified row that contains data. |
![Public Method](dotnetimages/publicMethod.gif) | NextNonEmptyRow | Overridden. Gets the index of the next non-empty row after the specified row index. |
![Public Method](dotnetimages/publicMethod.gif) | ParseFormula | Parses the string value and returns the expression for the cell at the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | Recalculate | Evaluates the formulas in the sheet that have changed since the last calculation cycle. |
![Public Method](dotnetimages/publicMethod.gif) | RecalculateAll | Evaluates all the formulas in the entire sheet (including those that have not changed since the last calculation cycle). |
![Public Method](dotnetimages/publicMethod.gif) | RemoveColumn | Removes a column at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | RemoveColumns | Removes one or more columns starting with the column at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | RemoveCustomFunction | Removes a user-defined custom function from the model. |
![Public Method](dotnetimages/publicMethod.gif) | RemoveCustomName | Removes a named expression from the model. |
![Public Method](dotnetimages/publicMethod.gif) | RemoveRow | Removes a row at the specified position. |
![Public Method](dotnetimages/publicMethod.gif) | RemoveRows | Removes one or more rows, starting with the specified row. |
![Public Method](dotnetimages/publicMethod.gif) | Serialize | Overloaded. Saves the object to XML. |
![Public Method](dotnetimages/publicMethod.gif) | SetAggregationType | Sets the AggregationType, as an enumeration value, at the specified column. If you pass null, it clears the AggregationType from that column. |
![Public Method](dotnetimages/publicMethod.gif) | SetArray | Overloaded. Sets an object array into a specified range of cells |
![Public Method](dotnetimages/publicMethod.gif) | SetExpression | Sets the formula, as an expression value, for the cell of the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | SetFormula | Sets the formula, as a string value, for the cell of the specified row and column. If you pass null, it clears the expression from that cell. |
![Public Method](dotnetimages/publicMethod.gif) | SetModelDataColumn | Overloaded. Binds a model column to a specified data source column. |
![Public Method](dotnetimages/publicMethod.gif) | SetNote | Overridden. Sets a user-defined note value for the cell at the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | SetTag | Overridden. Sets an application-defined tag value for the cell of the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | SetValue | Overridden. Sets the value for the cell of the specified row and column. |
![Public Method](dotnetimages/publicMethod.gif) | Swap | Swaps the specified ranges of cells. |
![Public Method](dotnetimages/publicMethod.gif) | UnparseFormula | Gets the formula, as a string value, from the specified expression for the cell at the specified row and column. |