I ka mahina i hala aku ONLYOFFICE e holoi nei, ua hoʻomohala
mākou i kahi macro e holoi ana i nā mea i loko o kahi pūlapala pepa ke
ʻike ʻia kahi huaʻōlelo like . Ma kēia pou moʻomanaʻo, e hoʻohana mākou
i ka loiloi like e hana i kahi macro e holoi ai i nā mea āpau ma hope o kahi huaʻōlelo kikoʻī i loko o kahi keena.
Pehea e ʻoki ai i ka ʻikepili pepa ma hope o kahi huaʻōlelo kikoʻī
me ka hoʻohana ʻana i ka macro ONLYOFFICE
ʻO ka mea mua, loaʻa iā mākou
ka pepa hana ikaika a me waihona helu kelepona ONLYOFFICE
e holoi ke koho ʻana i ka oWorksheet a me oRange variables, a hoʻ
onohonoho i ka huaʻōlelo a mākou e makemake ai e ʻimi i ka huaʻōleloReference variable.
A laila, me ka hoʻohana ʻana i ka loop forEach, hoʻololi mākou i nā cell i ka pae i koho ʻ
ia, mālama i ka waiwai o ka cell ma ka cellValue variable, a hāʻawi i ka cellValue a me ka huaʻōlelo e ʻimi ai i ke ala containsWord.
ʻO ke kūlana
nānā inā aia ka hua macro ONLYOFFICEʻōlelo i ʻōlelo ONLYOFFICE
e holoi ʻia i loko o ka waiwai kelepona. Inā ʻike ʻia ka huaʻōlelo,
hoʻonui ʻia ka waiwai cell i kahi substring o ka waiwai kumu, me ka wehe pono ʻana i nā mea āpau ma hope o ka huaʻōlelo i kuhikuhi ʻia.
ʻO ke ala macro ONLYOFFICE containsWord ʻIkepili Mea ONLYOFFICE e holoi ka hana nui o kēia macro. Lawe ʻia ma ke papa kuhikuhi adb ʻano he mau
palena ka waiwai o ke kelepona a me ka huaʻōlelo
e ʻimi ai. Hōʻoia inā macro ONLYOFFICE loaʻa kahi
huaʻōlelo ma ka ʻimi ʻana i kāna kuhikuhi i loko o nā kiko o ke kelepona. Hoʻihoʻi kēia hana i ka papa kuhikuhi kahi e hoʻomaka ai ka huaʻōlelo, a i ʻole ‘-1’ inā ʻaʻole ʻike ʻia ka huaʻōlelo.