SetNumber Method

Sets the value of the specified cell to the specified number and marks the workbook as needing calculation; the number is assumed to be a valid double precision floating point number.

[Visual Basic]
Overridable Sub SetNumber( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal number As Double _
) 

[C#]
virtual void SetNumber( 
   int row,
   int column,
   double number
);

[C++]
virtual void SetNumber( 
   int row,
   int column,
   double number
) 

[C++/CLI]
virtual void SetNumber( 
   int row,
   int column,
   double number
) 

Parameters

row

Specifies the row of the cell to set.

column

Specifies the column of the cell to set.

number

Specifies the number to place into the specified cell.

Remarks

See the IValues overview for warnings about using this method.

See ValidateNumber for information about validating numbers before placing them in a cell.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IValues Interface  | IValues Members  | ValidateNumber Method  | IsValidNumber Method  | Number Property  | DateTimeToNumber Method

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.