Previously, you saw that to get a particular portion of worksheets, you deploy these methods here,
get the values and then give the range over the sales.
So that's, for example, give us a five to f five.
So that portion now it's obvious that's one way to get a cell is to just use the same methods using
the same logic.
So for example, this one would be just the five.
So the five, we get that.
So that would be one way to get the value of a cell.
But this way, while it works, you also have to ads like an index of zero to get that in all of this
and then another index to get that string inside that list.
So that would give you the actual free string.
Therefore, you might be looking at other ways to get a cell.
So get cell using a cell.
A cell is another method, so get cell gets cells using a cell.
Let's say cell one.
Cell two is work sheets one that's a cell.
Again, here you do, for example, the five, and then you have to apply value at the end to extract
the actual value source cell of one cell to let's print them both.
And we get to same outputs three and three.
Right.
So that's another way to get the cell.
Now you can also search for a particular value.
For example, let's search for this minus 10.
To do that.
You do use worksheets, dot find in quotes, you search for a minus 10.
Now if you print Cell three, be aware that this is a cell object.
So it's not very useful, perhaps.
And if you want to get the coordinates of this, you would see Cell 3.0 cell three dots call or all
that.
And you get 16 five.
So one two three four five.
Yeah, that's the number of the column.
And 16 is the number of the rule here.
So it starts from one.
Now there are cases when you want to find all the cells that have a particular value.
For example, let's say we want to get all the cells that have minus nine as a value.
If that's case, we want to use another method.
Search for many cells, so let's say cells equal to work sheets, they'll find all.
And here you answer the stream.
So the value that you want to find and then here you print out the sales variable for now just to see
what we get.
And it will be a list, a list of all the sales.
So this is a first sale.
That's the second one.
That's a third one.
So three sales.
We're minus nine was a value, so actually it's four one two three four.
So we should have four here.
So one to three and four if you want to get the coordinates of these.
Of course, you could do something like for sale in sales, print sell the true sell that's called run
and you get.
An article that looks like that the coordinates of your cells so far, research for exact values.
For example, we searched for minus nine minus 10.
But what if you want to search to match partial streams?
Let's say we want to search all the cells, which have ninety nine in their values, which would be
all these cells, actually.
They all have 99.
So for that, we need to use a regular expression for that.
So we need the OAM imports a R e library which deals with regular expressions, and then let's create
a variable and that is already compile.
So we create a regular expression object first, which gets a string, a string of 99, and then the
cells are equal to worksheet one that finds all and as inputs.
You don't pull the string ninety nine, but that's a regular expression object.
So rec and yeah, let's print out the cells now.
That's variable, so run.
And these are all the values that have 19:9 in their body.
And that was the lost method I wanted to present to you for accessing cells.
And that's completes this video.
Thank you for following.
I'll talk to you later.