1
00:00:00,570 --> 00:00:04,800
In this video, you learn how to update a cell in a Google spreadsheet.

2
00:00:05,160 --> 00:00:13,380
So let's use our example here whether private is the spreadsheet I'm working on and I'm currently in

3
00:00:13,380 --> 00:00:15,780
the 2013 worksheet.

4
00:00:16,079 --> 00:00:19,080
Let's say I want to update this number here.

5
00:00:19,260 --> 00:00:22,800
This cell from minus 19 to minus 29.

6
00:00:23,340 --> 00:00:25,000
Now there are two ways to do this.

7
00:00:25,020 --> 00:00:25,980
Two different methods.

8
00:00:26,190 --> 00:00:34,830
One Methods allows you to update that cell using the A1 notation coordinate system so internal the native

9
00:00:35,130 --> 00:00:42,680
Excel Sheets or Google Sheet system, which means you want to point to that cell using, in this case,

10
00:00:42,690 --> 00:00:43,890
E five.

11
00:00:44,550 --> 00:00:46,110
That's kind of coordinate system.

12
00:00:46,590 --> 00:00:48,240
So let's do this first.

13
00:00:48,540 --> 00:00:50,100
I imported just operates.

14
00:00:50,100 --> 00:00:51,660
I establish a connection here.

15
00:00:51,960 --> 00:00:54,030
Got the spreadsheet object in here?

16
00:00:54,510 --> 00:00:59,610
Got the worksheets out of the spreadsheet and then update a cell.

17
00:01:02,030 --> 00:01:08,360
So you want to point to the worksheets, object to where the sale is and then use the updates methods,

18
00:01:08,750 --> 00:01:09,920
which gets a string.

19
00:01:10,030 --> 00:01:11,150
And this is the E!

20
00:01:11,280 --> 00:01:14,480
Five coordinates.

21
00:01:14,630 --> 00:01:17,150
Yeah, it was E five here.

22
00:01:18,320 --> 00:01:24,020
That's the first argument, the next argument is the new value you want to give to that cell.

23
00:01:24,290 --> 00:01:33,320
So let's say minus twenty nine, so from minus 19, we change it to minus 29 and run.

24
00:01:35,880 --> 00:01:43,500
As I wait for the scripts to execute, I'm going to wait and see the change is made real time.

25
00:01:44,130 --> 00:01:51,120
So I expect that the work sheet will be updated with a new value without me refreshing the browser.

26
00:01:51,970 --> 00:01:52,860
Yeah, so here we go.

27
00:01:53,010 --> 00:01:57,090
Now we got minus 29 as the new value now.

28
00:01:57,120 --> 00:02:01,860
Next, let's use a more mathematical coordinate system.

29
00:02:02,130 --> 00:02:08,220
So which means we want to count one column to three four five.

30
00:02:08,699 --> 00:02:17,040
The fifth column and one two three four five five zero fifth column.

31
00:02:18,350 --> 00:02:29,650
Again, update a cell based on a row, column worksheets, update sale.

32
00:02:30,800 --> 00:02:34,370
And this gets three arguments, so the first one is the rule.

33
00:02:34,400 --> 00:02:40,580
Five The column and the new value minus 39, for example, executes.

34
00:02:44,040 --> 00:02:46,290
And we got the new value updated.

35
00:02:46,680 --> 00:02:47,430
So here we go.

36
00:02:48,330 --> 00:02:51,270
It was minus 29 now he gets minus thirty nine.

37
00:02:52,320 --> 00:02:57,380
And that is how you update a single cell in the next video.

38
00:02:57,400 --> 00:02:59,560
We will update an entire column.

39
00:02:59,860 --> 00:03:00,580
So see you there.