Removes all the data from the specified range of cells.
Syntax
Parameters
- row
- Row index of start of range to clear
- column
- Column index of start of range to clear
- rowCount
- Number of rows to clear
- columnCount
- Number of columns to clear
Example
This example removes all the data (only) from the specified rows and columns.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.ClearData(0, 0, 3, 3); |
Visual Basic | Copy Code |
---|
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.ClearData(0, 0, 3, 3) |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also