InoteveraGaidhi rinotevera
How to Write Shell Scripts with AI
Tekinoroji
Nhungamiro yehunyanzvi
Kunyora zvinyorwa zvespredishiti uye macros neAI zvinoreva kutsanangura basa rinodzokororwa muChirungu chakajeka uye kuva nemubatsiri kugadzira VBA kodhi yeMicrosoft Excel kana Apps Script kodhi yeGoogle Sheets kuti uzviite.
Teerera kugwaro iriAI-yakarondedzerwa · ~3 min
Izvo zvine basa nekuti magwaro anogona kuita zvinhu mafomula haagone, sekutumira maemail, kurongazve mapepa kana kushanda pachirongwa, asi zvakare anoshandura data uye okuita panzvimbo yako, saka anoda kunyatsoyedzwa.
Mafomura anoverengera kukosha mumaseru; zvinyorwa zvinoita zviito. Kana basa iri "tarisa kumusoro mutengo" kana "total iyi column", fomula kana yakavakirwa-mukati fomula mubatsiri ndicho chirinani chishandiso. Kana basa riri "email munhu wese ane chimiro chakatenderwa", "patsanura shiti iri mumafaira gumi" kana "chenesa iyi kunze Muvhuro wega wega", unoda script. Desktop Excel inoshandisa VBA (Visual Basic for Applications), uye mabhuku ekushanda ane makros anochengetwa mumhando dzakaita macro-enabled dzakadai se.xlsm. Excel yewebhu haimhanye VBA asi inotsigira Office Scripts, iyo yakanyorwa muTypeScript. Google Sheets inoshandisa Apps Script, JavaScript-based platform yakavhurwa kubva kuExtensions, ipapo Apps Script. AI modhi dzakaona akawanda eVBA uye maApps Script uye anogona kazhinji kuburitsa kodhi yekushanda kubva pakutsanangurwa kwakajeka. Chikumbiro chakasimba chinotumidza chikuva, shizha uye mbiru dhizaini (semuenzaniso, "shizha rakanzi Vazvipiri, misoro mumutsara 1, email mukoromo B, chimiro mukoramu D"), chii chinofanira kuitika, uye chii chisingafanirwe kuitika, sekugadzirisa mitsara kaviri. Bvunza zvirevo mukodhi uye kuti script imire nemeseji yakajeka kana koramu inotarisirwa isipo. Edza zvakachengeteka. Shanda pakopi yefaira kutanga. Shanduko dzinoitwa ne macro kazhinji hadzigone kugadziriswa neCtrl+Z muExcel, saka yakanganisa kudzima loop inogona kupukuta data. Kune zvinyorwa zveemail, tumira kwauri kutanga, kana ita kuti script igadzire dhizaini kana rondedzero yevanogamuchira chero chinhu chisati chatumirwa. Apps Script inokukumbira kuti upe mvumo, sekutumira email sewe; verenga iro rondedzero, uye ngwarira kodhi yekukumbira kuwana kwakawanda kupfuura zvinodiwa nebasa. Mafungiro maviri asiri iwo akajairika. Macros haisi njodzi; njodzi inobva mukumhanya kodhi yausinganzwisise, kunyanya macros mukati mafaera kubva kune vausingazive. Uye AI-yakanyorwa kodhi haina kugadzirira kumhanya nekuti inotaridzika zvakanaka.
Murongi anozvipira anokumbira Google Apps Script iyo inotumira email kune mumwe nemumwe anozvipira mushizha nguva yake yekuchinja, uye anoiedza nekutumira meseji yega yega kukero yake kutanga.
An accountant anokumbira Excel VBA macro iyo inobvisa mitsara isina chinhu, inocheka dzimwe nzvimbo uye inomisa mafomati emazuva mukutumira kunze kwemwedzi, uye inomhanya chete pakopi yebhuku rebasa.
Mudzidzisi anokumbira chinyorwa chinotsemura giredhi rimwe giredhi pepa mune imwe tebhu yekirasi yega yega, uye anokumbira iyo AI kuti itaure chero loop kuitira kuti agoichengeta gare gare.
Muridzi webhizinesi diki anokumbira Apps Script ine chinokonzeresa chinofambiswa nenguva chinokopa maodha matsva ezuva rega rega mushizha rekuchengetera magwaro manheru ega ega.
Vatengesi veSpreadsheet vari kuvaka vabatsiri veAI zvakananga muzvigadzirwa zvavo, uye vamwe vanogona kutobatsira kunyora kana kutsanangura zvinyorwa mukati memupepeti. Izvo zvinovhura otomatiki kune vanhu vazhinji vasina kumbodzidza kukodha. Zvinoreva zvakare yakawanda isina kuongororwa kodhi inoshanda pane bhizinesi data uye email maakaundi. Masangano angangoda maitiro akareruka pane izvi: kuyedza pamakopi, kudoma muridzi wegwaro rega rega, uye kuongorora zvikumbiro zvemvumo. Unyanzvi hunogara huri kutsanangura maitiro nemazvo uye kutarisa kuti script inoita izvo chaizvo uye hapana chimwe.
Tsamba yemahara
Nhatu dzakasimbiswa dzeAI nyaya mangwanani ega ega pakati pevhiki, dzakanyorwa neChirungu chakajeka. Yemahara zvachose, hapana ads.
Imwe email zuva rega rega revhiki. Bvisa kunyoresa kamwe chete. Hatimbotengese kana kugovera kero yako.
Zviedze iwe pachako
Mhinduro yepakarepo pamhinduro yega yega, uye chitupa chinogovaniswa chine ID inobatika kana wapedza kosi.
Tsigira dzidzo yemahara yeAI. AI Understanding ndeye 501(c)(3) isingabatsiri - hapana ads, hapana paywall, zvachose. Ita chipo
Kunyora zvinyorwa zvespredishiti uye macros neAI zvinoreva kutsanangura basa rinodzokororwa muChirungu chakajeka uye kuva nemubatsiri kugadzira VBA kodhi yeMicrosoft Excel kana Apps Script kodhi yeGoogle Sheets kuti uzviite. Izvo zvine basa nekuti magwaro anogona kuita zvinhu mafomula haagone, sekutumira maemail, kurongazve mapepa kana kushanda pachirongwa, asi zvakare anoshandura data uye okuita panzvimbo yako, saka anoda kunyatsoyedzwa.
Mafomura anoverengera kukosha mumaseru; magwaro anoita zviito zvakadai sekutumira email. Dzimwe sarudzo ndeyekuverenga kana kufomatidza mabasa.
Google Sheets anoshandisa Apps Script, yakavhurwa kubva kuExtensions. VBA ndeye desktop Excel, uye Office Scripts ndeyeExcel yewebhu.
Nekuti zviito zvemacro kazhinji hazvigone kugadziriswa, loop isina kunaka inogona kuparadza data. Kopi inoita zvikanganiso zvisingakuvadzi.
Kutumira iwe pachako kana vanogashira matanda kunoratidza chaizvo zvaizotumirwa pasina kutumira email kuvanhu chaivo nekukanganisa.
Paunodzima mutsara padhuze nepamusoro, mutsara wega wega pazasi unokwira kumusoro, saka kumusoro-pasi loop inosvetuka pamusoro pemutsara uchangopinda panzvimbo.
Ramba uchidzidza
Mamwe madhairekitori akasarudzirwa nyaya iyi
InoteveraGaidhi rinotevera
How to Write Shell Scripts with AI
Tekinoroji