In this video, you learn how to update a cell in a Google spreadsheet.
So let's use our example here whether private is the spreadsheet I'm working on and I'm currently in
the 2013 worksheet.
Let's say I want to update this number here.
This cell from minus 19 to minus 29.
Now there are two ways to do this.
Two different methods.
One Methods allows you to update that cell using the A1 notation coordinate system so internal the native
Excel Sheets or Google Sheet system, which means you want to point to that cell using, in this case,
E five.
That's kind of coordinate system.
So let's do this first.
I imported just operates.
I establish a connection here.
Got the spreadsheet object in here?
Got the worksheets out of the spreadsheet and then update a cell.
So you want to point to the worksheets, object to where the sale is and then use the updates methods,
which gets a string.
And this is the E!
Five coordinates.
Yeah, it was E five here.
That's the first argument, the next argument is the new value you want to give to that cell.
So let's say minus twenty nine, so from minus 19, we change it to minus 29 and run.
As I wait for the scripts to execute, I'm going to wait and see the change is made real time.
So I expect that the work sheet will be updated with a new value without me refreshing the browser.
Yeah, so here we go.
Now we got minus 29 as the new value now.
Next, let's use a more mathematical coordinate system.
So which means we want to count one column to three four five.
The fifth column and one two three four five five zero fifth column.
Again, update a cell based on a row, column worksheets, update sale.
And this gets three arguments, so the first one is the rule.
Five The column and the new value minus 39, for example, executes.
And we got the new value updated.
So here we go.
It was minus 29 now he gets minus thirty nine.
And that is how you update a single cell in the next video.
We will update an entire column.
So see you there.