1
00:00:00,060 --> 00:00:08,970
Previously, you saw that to get a particular portion of worksheets, you deploy these methods here,

2
00:00:09,180 --> 00:00:14,220
get the values and then give the range over the sales.

3
00:00:14,940 --> 00:00:19,440
So that's, for example, give us a five to f five.

4
00:00:21,270 --> 00:00:28,560
So that portion now it's obvious that's one way to get a cell is to just use the same methods using

5
00:00:28,560 --> 00:00:29,850
the same logic.

6
00:00:30,120 --> 00:00:34,080
So for example, this one would be just the five.

7
00:00:34,410 --> 00:00:37,860
So the five, we get that.

8
00:00:39,980 --> 00:00:43,550
So that would be one way to get the value of a cell.

9
00:00:44,030 --> 00:00:53,930
But this way, while it works, you also have to ads like an index of zero to get that in all of this

10
00:00:53,930 --> 00:00:58,130
and then another index to get that string inside that list.

11
00:00:58,460 --> 00:01:01,750
So that would give you the actual free string.

12
00:01:02,180 --> 00:01:06,170
Therefore, you might be looking at other ways to get a cell.

13
00:01:06,500 --> 00:01:09,560
So get cell using a cell.

14
00:01:09,710 --> 00:01:14,510
A cell is another method, so get cell gets cells using a cell.

15
00:01:15,410 --> 00:01:16,730
Let's say cell one.

16
00:01:17,390 --> 00:01:21,710
Cell two is work sheets one that's a cell.

17
00:01:22,340 --> 00:01:29,090
Again, here you do, for example, the five, and then you have to apply value at the end to extract

18
00:01:29,090 --> 00:01:33,650
the actual value source cell of one cell to let's print them both.

19
00:01:34,070 --> 00:01:37,760
And we get to same outputs three and three.

20
00:01:38,540 --> 00:01:38,810
Right.

21
00:01:38,810 --> 00:01:40,340
So that's another way to get the cell.

22
00:01:40,700 --> 00:01:45,200
Now you can also search for a particular value.

23
00:01:45,200 --> 00:01:49,610
For example, let's search for this minus 10.

24
00:01:50,720 --> 00:01:51,350
To do that.

25
00:01:55,230 --> 00:02:02,840
You do use worksheets, dot find in quotes, you search for a minus 10.

26
00:02:03,800 --> 00:02:11,080
Now if you print Cell three, be aware that this is a cell object.

27
00:02:11,090 --> 00:02:13,580
So it's not very useful, perhaps.

28
00:02:14,120 --> 00:02:23,290
And if you want to get the coordinates of this, you would see Cell 3.0 cell three dots call or all

29
00:02:23,300 --> 00:02:23,630
that.

30
00:02:24,230 --> 00:02:27,740
And you get 16 five.

31
00:02:28,160 --> 00:02:31,850
So one two three four five.

32
00:02:32,240 --> 00:02:34,430
Yeah, that's the number of the column.

33
00:02:34,430 --> 00:02:37,010
And 16 is the number of the rule here.

34
00:02:37,520 --> 00:02:38,990
So it starts from one.

35
00:02:40,550 --> 00:02:46,010
Now there are cases when you want to find all the cells that have a particular value.

36
00:02:46,190 --> 00:02:51,500
For example, let's say we want to get all the cells that have minus nine as a value.

37
00:02:52,340 --> 00:02:54,860
If that's case, we want to use another method.

38
00:02:56,500 --> 00:03:04,960
Search for many cells, so let's say cells equal to work sheets, they'll find all.

39
00:03:06,230 --> 00:03:08,580
And here you answer the stream.

40
00:03:08,630 --> 00:03:16,640
So the value that you want to find and then here you print out the sales variable for now just to see

41
00:03:16,640 --> 00:03:17,180
what we get.

42
00:03:18,170 --> 00:03:22,580
And it will be a list, a list of all the sales.

43
00:03:22,610 --> 00:03:23,900
So this is a first sale.

44
00:03:24,140 --> 00:03:25,370
That's the second one.

45
00:03:26,090 --> 00:03:27,230
That's a third one.

46
00:03:27,830 --> 00:03:28,970
So three sales.

47
00:03:30,780 --> 00:03:37,530
We're minus nine was a value, so actually it's four one two three four.

48
00:03:37,980 --> 00:03:39,410
So we should have four here.

49
00:03:39,960 --> 00:03:46,440
So one to three and four if you want to get the coordinates of these.

50
00:03:46,470 --> 00:03:56,930
Of course, you could do something like for sale in sales, print sell the true sell that's called run

51
00:03:56,940 --> 00:03:57,900
and you get.

52
00:03:59,280 --> 00:04:07,500
An article that looks like that the coordinates of your cells so far, research for exact values.

53
00:04:07,830 --> 00:04:11,040
For example, we searched for minus nine minus 10.

54
00:04:11,610 --> 00:04:17,010
But what if you want to search to match partial streams?

55
00:04:17,040 --> 00:04:25,380
Let's say we want to search all the cells, which have ninety nine in their values, which would be

56
00:04:25,380 --> 00:04:27,260
all these cells, actually.

57
00:04:27,810 --> 00:04:29,490
They all have 99.

58
00:04:29,940 --> 00:04:34,180
So for that, we need to use a regular expression for that.

59
00:04:34,180 --> 00:04:43,260
So we need the OAM imports a R e library which deals with regular expressions, and then let's create

60
00:04:43,260 --> 00:04:46,200
a variable and that is already compile.

61
00:04:46,380 --> 00:04:54,780
So we create a regular expression object first, which gets a string, a string of 99, and then the

62
00:04:54,780 --> 00:05:02,970
cells are equal to worksheet one that finds all and as inputs.

63
00:05:02,970 --> 00:05:07,450
You don't pull the string ninety nine, but that's a regular expression object.

64
00:05:07,740 --> 00:05:11,610
So rec and yeah, let's print out the cells now.

65
00:05:11,820 --> 00:05:14,190
That's variable, so run.

66
00:05:15,770 --> 00:05:21,950
And these are all the values that have 19:9 in their body.

67
00:05:22,250 --> 00:05:27,860
And that was the lost method I wanted to present to you for accessing cells.

68
00:05:32,500 --> 00:05:34,450
And that's completes this video.

69
00:05:34,600 --> 00:05:35,470
Thank you for following.

70
00:05:35,500 --> 00:05:36,250
I'll talk to you later.