Spire.XLS API
Spire.XLS namespace
Spire.Xls
Workbook Class
Workbook Methods
AcceptAllTrackedChanges Method
AddCustomFont Method
AddDigitalSignature Method
AddPivotTableStyle Method
CaculateFormulaValue Method
CalculateAllValue Method
CalculateFormulaValue Method
ChangePaletteColor Method
ClearFontCache Method
ColumnWidthToPixels Method
ContainsFont Method
CopyTheme Method
CopyThemeColor Method
CopyToClipboard Method
CreateEmptySheet Method
CreateEmptySheets Method
CreateFont Method
CreatePivotStyle Method
Dispose Method
FindAllBool Method
FindAllDateTime Method
FindAllNumber Method
FindAllString Method
FindAllTimeSpan Method
FindBool Method
FindDateTime Method
FindNumber Method
FindString Method
FindTimeSpan Method
GetChartSheetByName Method
GetCustomFontParsedResult Method
GetDigitalSignatures Method
GetMatchingColor Method
GetOleSize Method
GetPaletteColor Method
GetSafeSheetName Method
GetSplitPageInfo Method
GetSplitPageTable Method
GetThemeColor Method
InitCalcEngine Method
IsPasswordProtected Method
LoadFromFile Method
LoadFromHtml Method
LoadFromMHtml Method
LoadFromStream Method
LoadFromXml Method
LoadTemplateFromFile Method
PasteFromClipboard Method
PixelsToColumnWidth Method
Protect Method
ProtectWorkbook Method
RejectAllTrackedChanges Method
RemoveAllDigitalSignatures Method
Replace Method
ResetPalette Method
Save Method
SaveAsImage Method
SaveAsTemplate Method
SaveAsXml Method
SaveChartAsEmfImage Method
SaveChartAsImage Method
SaveToFile Method
SaveToHtml Method
SaveToHttpResponse Method
SaveToMarkdown Method
SaveToStream Method
SetGlobalCustomFontsFolders Method
SetMaxDigitWidth Method
SetOleSize Method
SetThemeColor Method
SetWriteProtectionPassword Method
SprBpcmUuRG9jLkRvY3Vt Method
UnProtect Method
UnProtectWorkbook Method
XlsPageToImagedg Method
Click or drag to resize

Workbook FindAllNumber Method

Finds the cell with the input double.
Examples
This sample shows how to find all cells with specified doulbe value:
Copy 
<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Find cells with specified double value</para><para>CellRange[] result = workbook.FindAllNumber(100.32 , false);</para>

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public CellRange[] FindAllNumber(
	double doubleValue,
	bool formulaValue
)

Parameters

doubleValue
Type: System Double
Double value to search for.
formulaValue
Type: System Boolean
Indicates whether includes formula value to search for.

Return Value

Type: CellRange
Found ranges.
See Also