Uma usebenza ne -Google Sheets, ungachaza imithetho ehlanganisiwe, esuselwe kumsebenzisi yokuhlela amashidi okusebenzela, amakholomu, kanye nemigqa ngaphakathi kwespredishithi. Ngeshwa, ayikho indlela yokuvimbela ukufinyelela kokufunda. Lokhu kungaba usizo kakhulu ezimweni eziningi, isibonelo, ukubonisa amakhasimende akho kuphela amathikithi afanele wona, noma abasebenzi bakho kuphela amaphrojekthi abasebenza kuwo.
Isixazululo esisodwa esingaba khona ukudala ishidi eliyinhloko bese usebenzisa i-IMPORTRANGE ukufinyelela idatha ekhethiwe kuyo ngendlela eyodwa. Ngeshwa, lokhu kuhilela umsebenzi omningi wezandla: ukudala amashidi amasha, ukwabela izimvume zefayela, ukuthuthukisa nokusebenzisa ifomula ye-IMPORTRANGE, ukwamukela izimvume, kanye nokusetha ukufometha. Uma isakhiwo noma ifomethi ishintsha, lokhu kumele kwenziwe ngesandla kuspredishithi ngayinye ngayinye.
I- Google Apps Script elandelayo yenza lokhu ngokuzenzakalela. Uma usebenzisa indlela ye- init () kanye ku-mastersheet, wonke amashidi ezigqila ayenziwa ngokuzenzakalela, amalungelo abelwa bese amafomula nokufometha kusethwa. Uma idatha kushidi eliyinhloko ishintsha, ibonakala ngokuzenzakalela kushidi lesigqila. Uma ukwakheka kweshidi eliyinhloko kuguquka, mane usebenzise i-init () futhi (amashidi wangaphambilini abuyekezwa ngokuzenzekelayo).
82ba709df04366e65cb3a42f84f19631