How to access a cell

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?

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

I don’t found

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

can you be more explicit explaining what do you need?

@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”

image

CellValue is the Output of Read Cell.

2 Likes

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

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

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.

I mean without Read Cell. Use only IF


check the solution from this post buddy

Then You can make use of uiAutomation.

  1. Take and TypeInto Activity and Indicate the SearchBar
    image

  2. Type AD3 and Enter.

  3. Pass Hotkey : Ctrl+ C

  4. Get the Value in Clipboard,


Mukesh

How check fill cell or empty?

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

1 Like

Thanks a lot

But I have this error

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

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.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.