finding only numeric values in a worksheet using vb.net?
Hi all.
Maybe smb could make an advice how to do this:
I have to find all the rows in a Excel worksheet, which contain cell with a
11 digit numeric value.
E.g. two rows each with 3 cells with values:
------------------------------------
Will | Smith | 4524574561
Gerry | Smith | LowStreet 20
------------------------------------
So, the first row should be accepted, and the second - ignored.
I tried different examples using oSheet.Cells.Find(What:=...
but unsuccesfully.
Is there a way to use regular expressions
Thanks in advance.
|