How to access a cell

[RPA3]

Hello. I check if a particular cell in the excel file is filled with the specific value “hello”
How it check?
I read this cell and wrote it in the variable.
Further in IF what to write?
Or is it possible without Read Cell?

[vikas_reddy_Vicky (Vikas Reddy Kapu)]

I guess you are looking to

1. read a cell in an excel
2. store it in a variable
3. Use an IF condition to validate it.

Please make sure you use the below search button present in forum and search(in green) for your query. I am sure you will find few solutions. If not found please ask a question.

Thanks,
Vikas Reddy

[RPA3]

I don’t found

[vikas_reddy_Vicky (Vikas Reddy Kapu)]

please look into below links:
Read cell & store it in a variable: Excel - Read Cell - Variable Type
IF condition: If Condition on data entry

[fernando_zuluaga]

can you be more explicit explaining what do you need?

[Dipanshu (Dipanshu Rastogi)]

@RPA3

• Read range and store your excel into data table
• Use For each row till data table
• Add if condition row(“Column Name”).ToString=“text to be search”

[mukeshkala]

CellValue is the Output of Read Cell.

[Pradeep_Shiv]

you need to check if a rows as “hello” in it??

[RPA3]

Can I directly access the cell number in If? e.g. AD3

[mukeshkala]

In ReadCell Activity - replace “A1” with the your Cell Number.

In result Field - Presss Ctrl+K and Name the Variable as CellValue - This will create a generic variable for us.

[RPA3]

I mean without Read Cell. Use only IF

[fernando_zuluaga]

How To Count the Total Number of rows that contains a Keyword in Excel

Dears, How To Count the Total Number of rows that contains a Keyword in Excel? Thanks

check the solution from this post buddy

[mukeshkala]

Then You can make use of uiAutomation.

1. Take and TypeInto Activity and Indicate the SearchBar
   

2. Type AD3 and Enter.

3. Pass Hotkey : Ctrl+ C

4. Get the Value in Clipboard,

–
Mukesh

[RPA3]

How check fill cell or empty?

[mukeshkala]

String.IsNullOrEmpty(CellValue.ToString) or String.IsNullOrWhiteSpace(CellValue.ToString)

[RPA3]

Thanks a lot

[RPA3]

But I have this error

VisualBasicValue: Object reference not set to an instance of an object.

[mukeshkala]

Where Extactly is the Error .

NullReferenceException indicates that you are trying to access member fields, or function types, on an object reference that points to null. That means the reference to an Object which is not initialized.