Izikripthi Zehhovisi ku-Excel: Umhlahlandlela Ophelele Wokwenza Izincwadi Zakho Zokusebenza Zisebenze Ngokuzenzakalelayo

I-Los Ama-Office Scripts ayindlela yesimanje yokwenza i-Excel isebenze ngokuzenzakalelayo Itholakala kuwebhu, ku-Windows, naku-Mac, i-Office Scripts ikuvumela ukuthi urekhode izenzo, uzihlele njengekhodi ye-TypeScript, futhi uzisebenzise noma nini lapho ufuna—kusukela enkinobheni, kushejuli, noma kuhlanganiswe ne-Power Automate. Uma uphinda imisebenzi efanayo njalo ezincwadini zakho zomsebenzi, i-Office Scripts ingaguqula wonke lowo msebenzi okhathazayo ube inqubo eqhubekayo.

Kunokuba nje "enye indlela yokwenza ama-macro", Ama-Office Scripts ahlanganisa okungcono kakhulu kwe-Excel, ifu, kanye nemisebenzi yokusebenza ezenzakalelayoUngabelana ngemibhalo yakho nethimba lakho, uyixhumanise nezinye izinsizakalo, futhi ugcine amaspredishithi akho esesikhathini ngaphandle kokuvula amafayela noma ukuchofoza izinkinobho njalo.

Ayini ngempela ama-Office Scripts futhi kunini lapho kunengqondo ukuwasebenzisa?

I-Office Script, ngokuyisisekelo, isethi yemiyalelo i-Excel eyenzela wenaLe miyalelo ingavela ekuqopheni izenzo ozenzayo ngesandla noma ekhodini ye-TypeScript ebhalwe ngesandla. Uma isidaliwe, iskripthi singaphinde sisetshenziswe ezincwadini ezahlukene zomsebenzi kanye namaphepha okusebenzela, konge isikhathi futhi kuncishiswe amaphutha abantu.

Isimo esijwayelekile lapho zikhanya khona yilapho Uphinda ukulandelana okufanayo kwezinyathelo nsuku zonke noma njalo ngevikiVula ifayela, sula amakholomu, ufomethe, usebenzise amafomula, udale amathebula noma amashadi e-pivot, njll. Yonke leyo nqubo, engase ikuthathe imizuzu eminingana isikhathi ngasinye, ingathathwa kanye kuphela bese iqaliswa ngokuchofoza okukodwa.

Cabanga ukuthi zonke izinsuku zomsebenzi Ulanda ifayela le-CSV kusuka ohlelweni lwakho lokubala imali, uyivula ngaphakathi I-Excel bese uzenzakalela ukuhlanganiswaUsusa amakholomu ongawadingi, uguqule ububanzi bube ithebula, usebenzise izihlungi, ungeze amafomula, bese ugcina unethebula le-pivot eshidini elisha. Esikhundleni sokudala kabusha inqubo ngesandla, usebenzisa iskripthi sakho futhi ngemizuzwana ifayela selilungile, lihlala lilandela izinyathelo ezifanayo futhi ngaphandle kwezinyathelo ezingabanjwanga.

Enye inzuzo enkulu ukuthi Ungabelana ngalolo mbhalo nozakwenu.Akudingeki baqonde ukuthi wakha kanjani noma bazi noma yiluphi uhlelo; badinga nje ukusebenzisa iskripthi ukuze bathole umphumela ofanayo. Lokhu kusiza ukwenza izinqubo zibe zijwayelekile kuzo zonke ezezimali, ukubika, ukulawula ukuphathwa, ukuhlaziywa kwedatha, nanoma iyiphi indawo lapho i-Excel iyithuluzi lansuku zonke.

Irekhoda yesenzo: ukuzenzekela ngaphandle kohlelo

I-Stock Recorder iyisango lanoma ubani Ufuna ukwenza i-Excel ibe ngokuzenzakalelayo ngaphandle kokubhala umugqa owodwa wekhodi.Ukusebenza kwayo kufana kakhulu nokwe-macro recorder yakudala, kodwa umphumela ugcinwa njengesikripthi esisekelwe ku-TypeScript esikhundleni se-VBA.

Uma usebenzisa ukurekhoda, i-Excel Qopha imisebenzi oyenzayo eshidiniUkuhlela amaseli, izinguquko zokufometha, ukudalwa kwethebula, ukufakwa kweshadi, njll. Uma uyeka ukurekhoda, konke kuba iskripthi ongasisebenzisa futhi kwezinye izincwadi zomsebenzi, inqobo nje uma isakhiwo sihambisana (amagama amashidi, ububanzi, amathebula, njll.).

Inzuzo enkulu yale ndlela ukuthi Awudingi ulwazi lobuchwepheshe lwangaphambiliniUsebenza nje ngendlela ovame ukusebenza ngayo bese uvumela umrekhoda ukuthi aphathe ukuyiguqula ibe ikhodi. Kamuva, uma ufuna ukulungisa ukuziphatha kwesikripthi, ungasivula ku-Code Editor bese ulungisa imininingwane ethile.

Kumadokhumenti e-Microsoft uzothola iziqondiso zalolu hlobo “Rekhoda izenzo njengezikripthi ze-Office”lapho kuchazwa khona imikhuba emihle, imikhawulo (isibonelo, izici ezithile ze-Excel ezingakaqoshwa) kanye nendlela yokuhumusha lokho okwenziwa yirekhoda ukuze kube lula ngawe ukuyihlela kamuva.

Umhleli wekhodi: amandla aphezulu nge-TypeScript

Umhleli wekhodi yindawo lapho Uyahamba uyoshintsha iskripthi esenziwe noma lapho ubhala khona okusha kusukela ekuqaleni. Yilapho i-TypeScript, imodeli yezinto ze-Excel, kanye nawo wonke amakhono athuthukile ongakwazi ukuwalawula nge-interface kuphela aqala khona ukusebenza.

I-TypeScript iyi- i-superset ethayishiwe ye-JavaScriptLokhu kusho ukuthi konke okwaziyo ngeJavaScript kuyasiza, kodwa futhi unezinhlobo zokuhlela, ukuhlola, kanye nezici zosizo ezenza kube lula ukubona amaphutha. Ulwazi oluthile lokuhlela (ngisho nasezingeni eliyisisekelo) lunconywa kakhulu ukuze uthole okuningi kuma-Office Scripts.

Isikripthi ngasinye seHhovisi kumele sibe ne- umsebenzi oyinhloko obizwa ngokuthi mainLo msebenzi uthola into yohlobo njengepharamitha yawo yokuqala ExcelScript.Workbook, emele incwadi yokusebenzela ye-Excel lapho iskripthi sizosebenza khona. Ngokubanzi, isakhiwo sihlala silandela lesi simo:

function main(workbook: ExcelScript.Workbook) {
// Aquí va tu código
}

Ikhodi oyifaka ngaphakathi umsebenzi main Lokhu kuzoba yilokho okwenziwayo uma usebenzisa iskripthiUkusuka lapho, ungabiza eminye imisebenzi oyimemezelayo kufayela elifanayo, kodwa akukho lutho olungaphandle komsebenzi oluzokwenziwa ngokuzenzakalelayo. Ngaphezu kwalokho, iskripthi asikwazi ukubiza esinye iskripthi se-Office ngqo, yize singasebenzisana neminye nge-Power Automate sisebenzisa amapharamitha okufaka kanye namanani okubuyisa. main.

Izifundo ezisemthethweni, njengaleyo ye "Ukudala nokufometha ithebula le-Excel"Zikuqondisa isinyathelo ngesinyathelo kumhleli: indlela yokuhumusha ikhodi ekhiqizwe yirekhoda, indlela yokwengeza izimo if/else, ama-loop kanye nemisebenzi yokusiza, kanye nendlela yokulungisa amaphutha amancane angase avele njengoba ulungisa izikripthi zakho.

Imodeli yento ye-Excel ku-Office Scripts

Ukuze usebenze ngempumelelo nama-Office Scripts, kuyasiza ukuqonda Ihlelwe kanjani imodeli yezinto ze-Excel?Lo modeli ufana kakhulu nalokho okubonayo ku-interface uqobo: izincwadi, amashidi, amabanga, amatafula, amashadi, njll., konke kuhlobene ngokwezigaba.

Phezulu kukhona into Workbookokumelela incwadi yonke. Ukusuka lapho ungafinyelela amaspredishithi ayo usebenzisa izindlela ezifana nalezi getWorksheets() o getActiveWorksheet()Ishidi ngalinye, lona, ​​likuvumela ukuthi ufinyelele amaseli athile kanye nobubanzi.

I-Las amaspredishithi (Worksheet) aqukethe amabanga (Range)Amabanga angamaqoqo amaseli ahambisanayo. Amabanga angaba yiseli elilodwa (isibonelo, "B3") noma ibhulokhi lonke ("C2:F4"). Izakhiwo eziningi zedatha—amathebula, amashadi, amathebula e-pivot, izimo, izithombe, nezinye izinto zokuboniswa kwedatha—zakhelwe phezu kwamabanga.

Ama-API e-Office Scripts ahlelwe ngezikhala ezimbili eziyinhloko zamagama: OfficeScript y ExcelScriptAma-API ahlobene ngqo nezincwadi zomsebenzi ze-Excel kanye namaphepha okusebenzela atholakala ku- ExcelScript, kuyilapho lezo ezingancikile encwadini ethile zitholakala ngaphansi OfficeScriptIreferensi esemthethweni ichaza zonke izinhlobo nezindlela ezitholakala kuzo zombili amaphakheji.

Isibonelo esilula kakhulu semodeli yento yiskripthi esi ithola iqabunga elisebenzayo bese ikhombisa igama lalo kukhonsoli Kusuka kumhleli:

function main(workbook: ExcelScript.Workbook) {
let sheet = workbook.getActiveWorksheet();
console.log(sheet.getName());
}

Ukusebenza ngama-range: amanani, amafomula, kanye nokufometha

Ama-Ranges ayisisekelo sokusebenza nama-Office Scripts, ngoba Zisetshenziswa ukuphatha idatha, amafomula, kanye nokubukeka okubonakalayo kwamaseli.Ukuze kubhekwe ububanzi, inothi A1 livame ukusetshenziswa, kokubili kumaseli ngamanye kanye namabhulokhi.

Ububanzi ngabunye bunezilinganiso ezintathu ezibalulekile: amanani aqukethwe kumaseli, amafomula ahlolwayo, kanye nokufometha okusetshenzisiweNgezindlela ezifana getValues y setValues Uphatha idatha eluhlaza; nge getFormulas y setFormulas Usebenza ngamafomula; futhi ngokusebenzisa getFormat ufinyelela into RangeFormat okukuvumela ukuthi ushintshe imibala yokugcwalisa, amafonti, imingcele, njll.

Ngaphakathi, Amazinga amelwe njenge-matrices enezinhlangothi ezimbiliIsibonelo, uhlu lwemigqa emi-3 ngamakholomu ama-2 luzoba yi- any[][] ngezingxenye ezintathu (imigqa), ngayinye inamanani amabili (amakholomu). Lokhu kukunika ukuguquguquka okukhulu kokuphindaphinda nokucubungula idatha usebenzisa ama-loop noma imisebenzi ye-JavaScript/TypeScript array.

Isikripthi esivamile singadala umbiko omncane wokuthengisa: setha izihloko, uzifomethe, ugcwalise idatha, bese ubala ingqikithi kusetshenziswa amafomula ngaphakathi kobubanzi obuthile. Konke lokhu kwenziwa ngokushintshashintsha izakhiwo zobubanzi nokusebenzisa izindlela zokufometha ukuze umphumela ufundeke futhi ukhange ngokubonakalayo.

Kubalulekile ukukucacela lokho Inani langempela leseli alifani ngaso sonke isikhathi nalokho okubonayo esikrinini.. Isibonelo idethi ebonisiwe Isibonelo, i-“02/05/2021” ingahambisana ngaphakathi nenombolo engu-44318. Lokho okubonayo kuncike kufomethi yenombolo, kodwa uhlobo oluyisisekelo luhlala luyinombolo uze ushintshe inani.

Uma usebenzisa amanani ebanga ku-TypeScript, kuwumkhuba omuhle chaza ngokucacile uhlobo lwedatha oyilindeleIseli lingaqukatha elilodwa string, a number noma a booleanUma wazi ukuthi ububanzi obuthile buzohlala buqukethe izinombolo (isibonelo, ikholomu yentengo), ungayifaka kuyo. number[][] ukuze sikwazi ukwenza izibalo ngaphandle kokukhononda nge-TypeScript.

Isibonelo, ukuthola intengo emaphakathi kukholomu yedatha, ungamemezela into efana nale let prices = priceRange.getValues() as number[][]; bese udlula kuleyo matrix ukuze uhlanganise amanani bese uhlukanisa ngenani lemigqa.

Amathebula, amashadi, nezinye izinto zedatha

Ngaphezu kokulawula amaseli ngamanye, i-Office Scripts ikuvumela dala futhi ushintshe izakhiwo zedatha ezicebile njengamathebula, amashadi, amathebula e-pivot, izimo, noma izithombe. Lezi zinto zigcinwa emaqoqweni ahlobene namashidi okusebenzela noma incwadi yokusebenzela ngokwayo.

Amathebula akhiwe ngezinhlobo zedatha futhi avumela Sebenzisa ukufometha okuzenzakalelayo, izihlungi, kanye nezitayela ezichazwe ngaphambiliniIsikripthi singangeza ithebula elinezihloko ezine addTable(rango, true) futhi kusukela lapho, finyelela amakholomu ayo, imigqa, kanye nezakhiwo ezithile.

Kungenzeka futhi ukukhiqiza amagrafu ngendlela ehlelekile, usebenzisa izindlela ezifana addChartithini leskripthi dala ikholomu, umugqa, amashadi ephayi, njll. usebenzisa ububanzi bedatha njengomthombo. Ungalungisa ngisho nezakhiwo ezifana nendawo eshidini, usayizi, noma uhlobo lweshadi.

Ngokufanayo, amathebula e-pivot, izimo, nezithombe kungaphathwa kusukela kumaskripthi, kungakhathaliseki ukuthi kudalwa, kubuyekezwe, noma kusulwe. imibhalo yobuchwepheshe ye-Office Scripts Ihlanganisa ngokuningiliziwe zonke izigaba nezindlela ezitholakalayo zohlobo ngalunye lwento, kanye nezibonelo ezisebenzayo zokusetshenziswa.

Ezimweni eziningi zangempela, inhlanganisela yamathebula namashadi azenzakalelayo ikuvumela ukuthi Khiqiza imibiko elungele isethulo ngokuchofoza okukodwa.ngaphandle kokwakha kabusha ngesandla isakhiwo sombiko esifanayo njalo lapho kufika idatha entsha.

Amaqoqo nokufinyelela ezintweni eziningi

Uma into ye-Excel ihlanganisa izinto eziningana zohlobo olufanayo, ikwenza lokho ngamaqoqo aqukethe Zimelelwa njengama-array ku-TypeScript. Isibonelo, a Workbook ineqoqo le- Worksheet[], ofinyelela ngayo getWorksheets().

Umthetho ojwayelekile uwukuthi izindlela ezinamagama amaningi, njenge getTables(), getCharts() o getColumns()Zibuyisela iqoqo eliphelele lezinto zalolo hlobo. Uma usunalo lelo qoqo, ungasebenzisa imisebenzi evamile yeqoqo: phinda ulisebenzise nge forEach, ukufinyelela nge-index, filter, search, njll.

Ukuze ubuze into ethile, kuvame ukuba nezindlela ezihlukile ezifana nokuthi getTable(name) o getWorksheet(name)Lokhu kulindele isihlonzi noma igama ozobe uselinikeze ngaphambili, kungaba kusikripthi noma ku-interface ye-Excel. Uma isici sikhona, sibuyisela isibonelo esihambisanayo; ngaphandle kwalokho, sibuyisela i-null. undefined.

Indlela evamile kakhulu ukuhlola kusengaphambili. uma into isivele ikhona eqoqweniIsibonelo, ungazama ukuthola ithebula elibizwa ngokuthi "i-MyTable" futhi, uma ulithola, sebenza nalo; uma kungenjalo, lidale kusukela ekuqaleni. Le ndlela igwema amaphutha lapho iskripthi sisebenza ezincwadini zokusebenza ezinezakhiwo ezihlukile kancane.

Futhi kuyinto evamile, lapho kukhiqizwa imibiko okumele ibe negama elifanayo lethebula noma ishadi, ukususa into yangaphambilini kuqala (uma ikhona) bese kudala entsha. Lokhu kugwema ukungqubuzana kwamagama noma izinsalela zokugijima kwangaphambilini ezingadida abanye abasebenzisi.

Ukwengeza nokususa izinto ze-Excel ngezikripthi

I-Office Scripts ikuvumela ukuthi udale futhi ususe izinto zencwadi yokusebenzela ngendlela ehlelekile, okuyinto ebalulekile uma ufuna Ukubulawa ngakunye kushiya incwadi isesimweni esihlanzekile nesilawulwayoUkwengeza, kusetshenziswa izindlela add... entweni "engumzali"; ukuze ususe, vele ushayele delete() entweni uqobo lwayo.

Isibonelo, ispredishithi ivumela dala amathebula amasha nge addTableukudlulisa ububanzi bedatha nokuthi ngabe buhlanganisa yini izihloko. Leyo ndlela ibuyisela ithebula elisanda kudalwa, ongaliqamba ngalo setName() ukuze uyithole ngokushesha ekusetshenzisweni kwesikhathi esizayo noma kwezinye izikripthi.

Uma ufuna ukuqinisekisa ukuthi azikho izinsalela zetafula elidala ezisele, ungakwenza Zama ukuyilanda ngegama bese ususa ekhona ngaphambi kokudala entsha.Le ndlela isetshenziswa kabanzi ezinqubweni ezisebenza nsuku zonke ngedatha entsha, lapho ungafuni ukugcina umlando encwadini yokusebenza efanayo.

Ukususa kusebenza ngendlela efanayo nakwezinye izinto, njengespredishithi, amashadi, noma amathebula e-pivot. Mane nje uthole into bese ushayela... delete() ukuze inyamalale encwadini. Ukusuka lapho, ungakha kabusha lokho okudingayo ngedatha entsha.

Nokho, kuyalulekwa ukuthi uqaphele susa izinto ezibalulekile encwadiniIsibonelo, ukususa ispredishithi sokuqala kungabadida abasebenzisi abalindele ukuyibona lapho. Umkhuba omuhle ukubhala phansi ukuziphatha kweskripthi, futhi uma kungenzeka, usebenze kumaspredishithi adalelwe inqubo ezenzakalelayo.

Yabelana ngezikripthi bese uzisebenzisa kusuka ezinkinobho

Enye yamandla amakhulu e-Office Scripts ukuthi Abagcini nje ngokuhlala ku-akhawunti yakhoUngabelana ngazo nabanye abasebenzisi enhlanganweni yakho, ikakhulukazi uma besebenza ezincwadini ezabiwe efwini.

Uma wabelana ngeskripthi encwadini yokusebenzela eyabiwe, Wonke amalungu eqembu anokufinyelela kufayela angalibuka futhi alisebenzise. kusukela kuthebhu ethi Okuzenzakalelayo. Lokhu kuwusizo kakhulu ekulinganiseni indlela idatha ethile ecutshungulwa ngayo kanye nokuvimbela umuntu ngamunye "ekusunguleni" inguqulo yakhe yenqubo eyinhloko.

Ngaphezu kwalokho, i-Excel ivumela engeza izinkinobho eziqalisa izikripthi ngqo Kusukela ku-ribbon uqobo noma kugalari yesikripthi. Lezi zinkinobho ziyindlela elula yokuthi umuntu ongenalo ulwazi lwesikripthi abe nokufinyelela okubonakalayo ku-automation ayidingayo emsebenzini wakhe wansuku zonke.

Kusukela kumenyu yokuqukethwe kwe-Code Editor (etholakala nge-ellipsis eduze kwegama lesikripthi) ungakwazi Shintsha igama lesikripthi, ulisuse, noma ulihlanganise ne-Power AutomateUngayifaka futhi iribhoni ukuze ibonakale njengesenzo esihlukile endaweni yakho yokusebenza.

Kumadokhumenti uzothola izigaba ezinikezelwe ku- “Ukwabelana ngezikripthi ze-Office ku-Excel” kanye “Nokudala inkinobho yokusebenzisa isikripthi se-Office”, echaza indlela yokusetha izimvume, lokho abasebenzisi abangakwenza ngezikripthi ezabiwe, kanye nokuthi yimiphi imikhawulo yokuphepha esebenzayo yi-Microsoft 365.

Hlela ukwenziwa okuzenzakalelayo kwezikripthi

Ngaphandle kokuzisebenzisa ngesandla, ama-Office Scripts angaba hlela ukuthi zisebenze ngokuzenzakalelayo ngesikhathi esithileSisebenzisa ukuhlanganiswa kwayo ne-Power Automate, lokhu kulungele ukuqinisekisa ukuthi izincwadi ezithile zigcinwa zisesikhathini ngaphandle kokungenelela komuntu.

Umqondo ulula: uma usunesikripthi esenza umsebenzi owudingayo, Uyixhumanisa nokugeleza kwe-Power Automate. lokho kuyiqalisa ngezikhathi ezithile (isibonelo, njalo ekuseni ngo-8:00). Ngisho noma incwadi ivaliwe, umsebenzi uyayivula ngemuva, usebenzise iskripthi, futhi ulondoloze izinguquko.

Ukuze ulungiselele lolu hlelo, vula iskripthi ku-Code Editor bese ubheka isigaba se- "Ukubhala phansi"Ukusuka lapho, ungena ngemvume nge-akhawunti yakho ye-Excel nge-Power Automate, uchaze imvamisa yokusebenza, bese uchofoza ku-"Dala ukugeleza." Kusukela ngaleso sikhathi kuqhubeke, iskripthi sizosebenza ngokuzenzakalelayo ngokweshejuli oyichazile.

Le ndlela inciphisa kakhulu ukungqubuzana emisebenzini efana buyekeza imibiko yansuku zonke, noma ubale kabusha amamodeli ancike kumanani angaphandle. Uma ukugeleza sekusethiwe, ungakhohlwa ngokuqala inqubo ngesandla.

Nokho, kubalulekile ukuqaphela izinto ekuqaleni. ukugeleza kusebenza ngaphandle kwamaphuthaUma yehluleka ngoba igama leshidi lishintshiwe, ithebula lisusiwe, noma isakhiwo sencwadi yokusebenza sishintshiwe, i-Power Automate izobonisa lawo maphutha, futhi ungawabuyekeza ku-run logs.

Ukuxhuma ku-Power Automate kanye nezinye izinsizakalo

I-Power Automate iyisevisi ye-Microsoft yokudala imisebenzi ezenzakalelayo phakathi kwezinhlelo zokusebenza nezinsizakaloUkuhlanganiswa nama-Office Scripts kuvumela ukuthi ama-script akho angaxhomeki kuphela ezenzweni ezingaphakathi kwe-Excel, kodwa aqalwe yimicimbi yangaphandle futhi ahlanganiswe namanye amathuluzi.

Ngale nhlanganisela ungakwazi, isibonelo, Sebenzisa iskripthi njalo uma i-imeyili ifika nesinamathiselo esithile.Isibonelo, ama-Office Scripts angabuyekeza ibhuku lokusebenza lapho into ingezwa ohlwini lwe-SharePoint noma aqalise ukucutshungulwa kwedatha lapho kuqala umsebenzi wokugunyazwa. Lokhu kwenza ama-Office Scripts abe yingxenye eyodwa ngaphakathi kohlelo lokusebenza olusebenza ngokuzenzakalelayo olubanzi kakhulu.

Idatha ishintshaniswa phakathi kokugeleza kwe-Power Automate kanye neskripthi ngokusebenzisa amapharamitha okufaka kanye nenani elibuyiselwe ngumsebenzi mainNgamanye amazwi, ungadlulisa ulwazi kusukela ekugelezeni uye kusikripthi (isibonelo, igama lefayela noma ububanzi obuqondiwe) bese ubuyisela umphumela ozosetshenziswa ukugeleza kamuva (njengenani elibalwe noma isimo).

I-Microsoft inikeza izifundo ezithile, njengokuthi "Ukusebenzisa Ama-Office Scripts Ngokuzenzakalelayo Kwamandla"Lesi sigaba sichaza ngezenzo ezitholakalayo, isakhiwo sesixhumi, kanye nezibonelo zezimo zokusetshenziswa ezivamile. Siwusizo ikakhulukazi kulabo abavela ezweni le-Excel abafuna ukuqhubekela phambili ezenzakalelayo zohlelo lokusebenza oluhlanganisayo.

Empeleni, abasebenzisi abaningi bahlanganisa ama-Office Scripts kanye I-Power Query nezinye izingxenye ze-Power PlatformIsibonelo, i-Power Query yokungenisa nokuguqula idatha, ama-Office Scripts ukusebenzisa i-business logic ethile encwadini yokusebenza, kanye ne-Power Automate ukuhlela konke ukugeleza ngemuva.

Ukutholakala, ukwenziwa kwesikripthi, kanye nokuxazulula izinkinga

Ukuze usebenzise ama-Office Scripts udinga ilayisensi ye-Microsoft 365 ehambisanayo nokuthi inhlangano yakho ayikaze ikhubaze lesi sici kusukela Isikhungo Sokuphatha noma ngezinqubomgomo zeqembu. Ngaphezu kwalokho, i-Excel kuwebhu idinga ukuthi amakhukhi ezinkampani zangaphandle avunyelwe.

Kwezinye izindawo zeWindows kuyadingeka faka i-WebView2 ukuze izingxenye ezithile zesipiliyoni zisebenze kahle. Kubalulekile futhi ukuqinisekisa ukuthi awusebenzisi i-akhawunti yangaphandle noma yezivakashi kumqashi, njengoba lokho kungavimbela ukufinyelela kumaskripthi.

Ukuze usebenzise iskripthi, uvame ukuya kuthebhu Okuzenzakalelayo > Buka izikripthiLapho uzobona igalari enezikripthi zakamuva. Ukukhetha eyodwa kuzoyivula ku-Code Editor, lapho ungachofoza khona inkinobho ethi "Run" bese ubona isaziso esifushane ngenkathi iskripthi sicutshungulwa.

Uma kukhona okungahambi kahle ngesikhathi sokubulawa, Amaphutha avela ku-Code EditorInkinobho ethi "Buka amalogi" iyatholakala, ekhombisa isifinyezo senkinga phansi kwephaneli. Lokhu kuvame ukubangelwa umehluko phakathi kwezincwadi zomsebenzi: amagama amashidi ashintshile, amathebula angasekho, ububanzi obushintshiwe, njll.

Kufanele ugcine engqondweni ukuthi Akuzona zonke izici ze-Excel ezisekelwa yi-recorder noma ama-API. ngaso sonke isikhathi. I-Microsoft iyanda kancane kancane ukuhambisana, kodwa izenzo ezithile zingase zibonakale ziphawulwe ngokuthi "azisekelwa" kuphaneli yokurekhoda futhi ngeke zifakwe kuskripthi.

Uma udinga usizo olwengeziwe, umphakathi wezobuchwepheshe we-Excel kanye nezinkundla zokusekela ze-Microsoft yizindawo lapho Ungabelana ngolwazi lwakho, imibuzo, noma izinkinga nge-Office ScriptsAbasebenzisi abaningi baphawula ngendlela abahlanganisa ngayo la mathuluzi ne-VBA, i-Power Automate, i-Power Query, nezinye izingxenye ukuze bathole okwengeziwe kudatha yabo.

Sekukonke, i-Office Scripts inikeza indlela enamandla kakhulu yokwenza Thuthukisa ukuzenzekela kwe-Excel uye ezingeni elilandelayoUkuhlanganisa ukubhala kwesimanje, ukusebenza kwamafu, ukuhlela imisebenzi, kanye nokugeleza kohlelo lokusebenza oluhlanganisiwe. Nakuba kukhona umugqa wokufunda, ikakhulukazi uma uvela ku-VBA noma ungakaze usebenzise i-TypeScript, isikhathi esichithwe sihumusha sibe izinqubo ezisheshayo, amaphutha ambalwa, kanye namaqembu asebenza ngokuqhubekayo kudatha efanayo.

I-athikili ehlobene:

Izikripthi Zehhovisi ku-Excel Web: Umhlahlandlela Ophelele Wokwenza Izincwadi Zakho Zokusebenza Zisebenze Ngokuzenzakalelayo

Isaka

Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.