How to validate input data from Excel to desktop application ,input is number or alphabets?

Help
, , ,
1

I’m getting below attached error , can anyone help me out to resolve this issue.

IMG-20181009-WA0014
IMG-20181009-WA00142250×4000 2 MB
IMG-20181009-WA0012
IMG-20181009-WA00122250×4000 1.16 MB

2

Hi @Naveen.Ch,

In this case, you will need to cast it before using the method All.

Please try it and let us know.

3

Thanks for the quick response.

Can you please elaborate @acaciomelo

without validation im able to send the data into desktop application…but i want to validate the its a numeric values or alphabets

if input value contain alphabet value it should throw exception.

4

Please try something like this:

Cash.AsEnumerable().All or CType(Cash, IEnumerable).All

2 Likes
5

Along with casting you should change data type from generic to specific type

6

Hi @Divyashreem
I am giving input from Excel file to desktop apication ,that one I’m taking as as string variable

I’m changing to generic to string type also I’m getting same error.

7

but while you assigning value to variable That should be of the type Enumerable then you can perform like Cash.AsEnumerable().All or CType(Cash, IEnumerable).All

8

Please find the above attachedTransactions.xlsx (8.3 KB)
Testing.xaml (26.4 KB)
work flow and excel sheet please do need full.

9

Hi @Naveen.Ch,

Is something like this that you are looking for?

image

1 Like