Excel Validation

[NagaYaparla]

Hi...

I am working with Excel where I need to validate some business rules... The business will enter data manually..
condition is data has to be numeric..

	Emplnumber
A2	12345A
A3	34678-
A4	w657@
A5	12345
A6	8965*
A7	86957'

in the above table where emplnumber is not numeric, I want to validate that data and send it to the business that A2, A3, A4, A6, A7 has an exception.
If anyone has any idea please comment on this post...

Thanks in advance..





------------------------------
Naga Yaparla
Developer
Capgemini
Europe/London
------------------------------

[david.l.morris]

Here's the thing. The best way for you to get help on solutions is to provide information about what you have tried already. What you're looking to do sounds pretty easy, but it feels a bit weird to respond with a solution when I'm not sure you've tried anything.

So, could you explain what trouble you're running into? For example, are you using the Excel VBO or are you trying to manipulate Excel by spying with Application Modeller? Are you trying to validate this while leaving the data in Excel? Are you having trouble reading the data into Blue Prism? Are you able to read the data but you need to know how to identify which cell it came from (A2, A3, etc.)? I'm just not sure what part you're struggling with.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

[NagaYaparla]

Hi Morris..

Appreciated for quick response..

Apologies... I am new to Blue prism..

I read data from Excel to collection and I am using Cal stage-->ToNumber(Collectionname.FieldName) I am able validate data.Suppose if the data is 12345- actually it has to written "False" but it's written "True". When i use test data 123@,345x,1456^,7890& it's written "False". ToNumber() is considering  "-" as numeric. Could you please let me know how to overcome this kind of validations..

Thanks in Advance...

------------------------------
Naga Yaparla
Developer
Capgemini
Europe/London
------------------------------

[Eric_ScottHerma]

@ Naga Yaparla

I'm not sure if I follow you correctly but basically you wish to determine whether values in a collection are either numeric or non-numeric, where numeric values are the correct input type? Also - how do you get true/false values out of the ToNumber() function - my understanding is that this function converts a string to a double?

Anyways, I think your approach is incorrect. You are using a conversion function to perform validation. I would use something such as isNan() or a regex expression to validate the values instead.

An even better method is to enforce validation in Excel itself from the very start using pre-defined validation criteria.​

------------------------------
Eric Scott Herman Digital Process Automation Specialist
------------------------------