Very nice and clear tutorial. Thank you. As a suggestion, that would be nice a part 2 explaining how to get the range address automatically, by just pointing out the most top-left cell (origin and destination).
Excellent tutorials, issues of transcendence, especially because it is an uncommon work, but has a huge future of usefulness because it is an application on the network and also a calculation tool that maybe in the near future can be complemented with Advantages of Excel. I greatly appreciate your work and please include me on your subscriber list.
I'm trying the appendRow() method instead of setValues(), in order to paste to another spreadsheet, and I'm getting something like "[Ljava.lang.Object;@432f7988"... Do I have to translate that to get the values? Thank you!
If I'm running a script, doing a loop, how could I get getRange(1, 1) to be recognized as 'A1'. Then as it runs through the script it would reference the corresponding cell.
Hi, nice tutorial. But how would you copy the range to blank rows underneath? For example, I have data on Rows 1:7 and I want to copy rows 1:7 to 9:16 and next time I want to copy to Rows 18:26 and so on....Thanks
any chance you will make a video on making a form using a sheet and app scripts? I have some knowledge on this but sure you would do a better job at this.. again great video, real easy to follow.
Thans for this excellent video! One question: I have a very large range that I'd like to get into an array for manipulation. Can I just format the column of text as text and then not need to manually go through and put " " around each cell? If you could address the issues in large ranges and arrays it would be great. (I subscribed to your excellent channel here). - John
@@ExcelGoogleSheets yes this works with an anrray like var = [1,2,3]. But not with the array i created by temp=activeSheet.getRange("A7:D7") --> temp[0]?
Sir if possible plz post a video to get input from html & return the result from sheet to html Like use Google sheet as a database/ server which calculate based on user input in html & return the result in html Thank you in advance Learning a lot from your videos
Good, but better: go full circle from range to an array, and back to a range. This put a range into an array, but doesn't do any additional work on it. Instead, an array is manually created, and written back to a range. Helpful, but most work is full circle - pull a range, do some work, then write back (parts of) the array to a range.
I thought this video would explain how to take range data from google apps script and use it in javascript in html file. Because simple range is represented by simply a string of comma separated values. You can't use that in javascript. There's gotta be some way to convert this range data to an object or array in javascript.
This is not directly tied to your video, but all of a sudden I can no longer edit my javascript files. Even though I try to after logging into my gmail account,and they reside on my google drive. Apparently I now need to get permission from Google to edit my own files? No one else uses them, is there a quick fix to this or do I need to go back to LibreOffice? Any advice apprecieated.
I like the way you teach. You explain everything in a clear easily understandable way. Looking forward to the next video.
Your channel is awesome! You helped me a lot, thanks. Keep doing a good work!
Very nice and clear tutorial. Thank you.
As a suggestion, that would be nice a part 2 explaining how to get the range address automatically, by just pointing out the most top-left cell (origin and destination).
Check my how to find last row video.
Excellent tutorials, issues of transcendence, especially because it is an uncommon work, but has a huge future of usefulness because it is an application on the network and also a calculation tool that maybe in the near future can be complemented with Advantages of Excel. I greatly appreciate your work and please include me on your subscriber list.
I'm trying the appendRow() method instead of setValues(), in order to paste to another spreadsheet, and I'm getting something like "[Ljava.lang.Object;@432f7988"...
Do I have to translate that to get the values?
Thank you!
Thank you. Ur awesome. I wish i could double like this video.
If I'm running a script, doing a loop, how could I get getRange(1, 1) to be recognized as 'A1'.
Then as it runs through the script it would reference the corresponding cell.
Is there a way to exclude blank rows from getRange or paste values only excluding blank rows?
Excellent tutorial
Hi, nice tutorial. But how would you copy the range to blank rows underneath? For example, I have data on Rows 1:7 and I want to copy rows 1:7 to 9:16 and next time I want to copy to Rows 18:26 and so on....Thanks
any chance you will make a video on making a form using a sheet and app scripts? I have some knowledge on this but sure you would do a better job at this.. again great video, real easy to follow.
Superb video for novices like me
Keep them coming
Thanks
Do you have a tutorial on how to execute - currentregion, select.end, offset vba togsheet app? Thanks
Hello Teacher!
How to write data to spreadsheet which is cells/ rangs merged by using Google script .
Deeply thanks
Thans for this excellent video! One question: I have a very large range that I'd like to get into an array for manipulation. Can I just format the column of text as text and then not need to manually go through and put " " around each cell? If you could address the issues in large ranges and arrays it would be great. (I subscribed to your excellent channel here). - John
try one of these
range.setNumberFormat('@');
range.setNumberFormat('@STRING@');
hi thanks for this great tutorial
How i can get an apecific element out of an array? var temp=activeSheet.getRange("A7:D7").getValues(); var a = temp[2]?
ua-cam.com/video/tZdSa6p3PHQ/v-deo.html&list=PLv9Pf9aNgemvD9NFa86_udt-NWh37efmD
@@ExcelGoogleSheets yes this works with an anrray like var = [1,2,3]. But not with the array i created by temp=activeSheet.getRange("A7:D7") --> temp[0]?
temp[0][0]
The playlist I linked includes everything you need to know about this topic.
Sir if possible plz post a video to get input from html & return the result from sheet to html
Like use Google sheet as a database/ server which calculate based on user input in html & return the result in html
Thank you in advance
Learning a lot from your videos
i would love that too
Good, but better: go full circle from range to an array, and back to a range. This put a range into an array, but doesn't do any additional work on it. Instead, an array is manually created, and written back to a range. Helpful, but most work is full circle - pull a range, do some work, then write back (parts of) the array to a range.
I thought this video would explain how to take range data from google apps script and use it in javascript in html file. Because simple range is represented by simply a string of comma separated values. You can't use that in javascript. There's gotta be some way to convert this range data to an object or array in javascript.
Thank you.
This is not directly tied to your video, but all of a sudden I can no longer edit my javascript files. Even though I try to after logging into my gmail account,and they reside on my google drive. Apparently I now need to get permission from Google to edit my own files? No one else uses them, is there a quick fix to this or do I need to go back to LibreOffice? Any advice apprecieated.
Seems like temporary block. I'm curious, did this get back to normal?
Nope. I thought I might have goofed up my settings, but apparently not. Thanks for your videos, but looks like I'm headed back to LibreOffice.
This is awesome!! Subscribe to this guy
🙏🏻
text