Excel Column data filter

Hi Team,

I have to check if a column has numbers only or varchar data.
i don’t need to filter records, i need result like column3 has varchar data

Thanks,
Radha

Read the excel and output as datatable dt1.

For each row in dt1
If IsNumeric(row(3)) then yes, else no

2 Likes

will it consider double data type as well?

lets try it

how to check absolute value