Ulwenza njani uluhlu lokudlala lukaYouTube usebenzisa iSpreadsheet sikaGoogle
Yenza lula Uluhlu lokudlalayo lweYouTube usebenzisa i-spreadsheet sikaGoogle Ngesikhokelo esilula nesilula esiya kukunceda wenze lula ingqokelela yeendaba ozithandayo ngokucofa nje kube kanye. Ngoko landela isikhokelo esingezantsi ukuze uqhubeke.
Ukuba ukwi-intanethi, ngokuqinisekileyo usenokuba usebenzise i-YouTube, kwaye ukuba uqhelene nokusebenzisa i-youtube, kukho umsebenzi omnye we-youtube onokuthi ngawo wenze uluhlu lwakho lokudlalayo ukuze iividiyo zakho ozithandayo zigcinwe kuyo. . Ngoku ukuqwalasela uluhlu lokudlalayo kwi-youtube kunokuba lula kakhulu, vele uhambe ngeendlela ezithile kwiakhawunti yakho kwaye uzenzele olwakho uluhlu lokudlala. Kodwa kuthekani ukuba ufuna ukuyidala ngePhepha likaGoogle? Oku kunokuvakala kubudenge kuba iGoogle Sheets luhlobo olwahluke ngokupheleleyo lwesicelo sekhompyuter esingenanto yakwenza ne-youtube, kodwa linda inokwenziwa. Apha kweli nqaku, sixoxe ngendlela eyodwa onokuthi ngayo wenze uluhlu lokudlala lwe-Youtube usebenzisa uluhlu lokudlala lukaGoogle! Funda nje lonke inqaku ukuze ufunde ngale ndlela. Indlela eya kusebenza ngayo kunye nokuhlelwa kwe-URL ziiseti ezilula zee-URL kwaye unokwenza lula kwaye usebenzise uluhlu lokudlala olufunayo ngokuthe ngqo kwi-spreadsheet sakho sikaGoogle. Ke jonga isikhokelo esipheleleyo esixoxwe ngezantsi ukuze uqhubeke.
Ulwenza njani uluhlu lokudlala lukaYouTube ngeSpreadsheet sikaGoogle
Apha ngezantsi sisikhokelo esipheleleyo ngesinyathelo ekufuneka usilandele esiya kukunceda wenze uluhlu lokudlala lwe-youtube usebenzisa i-spreadsheet sikaGoogle. Ngoko jonga la manyathelo angezantsi.
Amanyathelo okudala uluhlu lokudlala lweYouTube usebenzisa iSpreadsheet sikaGoogle:
1. Okokuqala, vula isicelo se-spreadsheet kwikhompyutheni yakho, yenza i-spreadsheet esitsha kwiGoogle, uze ubeke i-URL yevidiyo ye-youtube oyifunayo kwikholomu A (ividiyo enye ngeseli kwaye uqale ngekholomu A3 yephepha ). Emva kokungena I-URL yevidiyo Kwiseli A, ikholamu B ibonisa i-ID yevidiyo kunye nekholamu C iya kukubonisa i-thumbnail yevidiyo.
2. Ngoku faka kwiiseli i-URL yevidiyo yeevidiyo ozifunayo ongathanda ukuyibonisa kuluhlu lwakho lokudlala lwe-youtube, emva koko uya kubona ukuba uluhlu lwadlalwayo olutsha lwe-youtube luya kuhlaziywa kwi-akhawunti. Ungabelana nge-spreadsheet sikaGoogle nabani na ii-URL ukuze bazibandakanye noluhlu lwakho lokudlalayo.
3. Ngoku ucinga ukuba ingenzeka njani le nto? Into kukuba i-REGEXTRACT ifomula ye-spreadsheets isetyenziselwa ukukhupha i-ID yevidiyo ye-youtube kwi-URL oye wayinamathisela kwiiseli kwaye emva kokuba i-ID yevidiyo ikhona, iifomyula zemifanekiso zisetyenziselwa ukufumana i-thumbnail yevidiyo.
REGEXTRACT Formula: =REGEXTRACT(A3,"yotu(?:.*VvVI *v=I.beVI.*?embedV)([A-Za-z0-9_\-]{11})")
Ifomula yomfanekiso: +IMAGE(“https://i3.ytimg.com/vi/”&B3&”/hqdefault.jpg”,4, 80, 120)
4. Okokugqibela, iifomula ezenza uluhlu lokudlalayo lwe-Youtube kunye nokwenza ikhonkco elithe ngqo ne-Youtube:
+HYPERLINK(“https://www.youtube.com/watch_videos?video_ids=”&join(“,”,B3:B);”Linki”)
Qaphela: Iividiyo zikaYoutube ozibeke kuluhlu lwakho lokudlala aziyi kulungelelaniswa kwiakhawunti yakho kaGoogle ngokusebenzisa iSpredishithi zikaGoogle, ke kuya kufuneka uzihlaziye ngesandla ukuba ufuna ukuvumelanisa iifidi zakho ezibukhoma kwispreadsheet sakho.
Ngoku ugqibile ukwenza njani uluhlu lokudlala lweYouTube usebenzisa iSpreadsheet sikaGoogle. Nangona kunjalo, le nto isenokubonakala ingaqhelekanga kuwe kwaye ungakholelwa kuyo yonke loo nto, kodwa inyaniso kukuba ungayenza. Ukuze uqiniseke ngendlela, kufuneka uzame ukuyisebenzisa ngokwakho kwaye wenze uluhlu lokudlala lwe-youtube ngokusebenzisa i-Google Sheets. Ndiyathemba ukuba uyasithanda isikhokelo, wabelane nabanye kwaye ushiye uluvo olungezantsi ukuba unayo nayiphi na imibuzo enxulumene noku njengeqela letekhnoloji liya kuhlala likhona ukukunceda ngeengxaki zakho.
