Yadda ake Rubuta JavaScript Macros a cikin Dokokin KAWAI

Shin dole ne ku yi aiki tare da takaddun Kalma, maƙunsar rubutu na Excel, ko gabatarwar PowerPoint kuma kuna buƙatar maimaita ayyuka masu rikitarwa akai-akai? Misali, kuna buƙatar haskaka dabi'u kwafi a cikin takardar ko cire sifofi daga nunin faifan gabatarwa.

Idan haka ne, yana iya zama ƙalubale gare ku a matsayin mai amfani da Linux. Yin irin waɗannan ayyuka da hannu ba shi da ma'ana. Ana iya yin ayyuka daban-daban da yawa cikin sauƙi ta atomatik tare da VBA macros a cikin Microsoft Office. Duk da haka, akwai matsala mai tsanani - ba sa aiki na asali a kan na'urorin Linux.

Duk da haka, akwai wata dabarar warware wannan matsala. Kuna iya rubutawa da gudanar da macros na JavaScript a cikin Dokokin KAWAI don yin ayyuka na yau da kullun.

Karanta wannan labarin don sanin yadda.

Teburin Abubuwan Ciki

Menene Dokokin OFFICE KAWAI?

ONLYOFFICE Docs babban buɗaɗɗen tushe ne kuma ɗakin ofishi mai sarrafa kansa wanda aka tsara don ƙirƙirar yanayin haɗin gwiwa na gida akan sabar Linux ko Windows.

Yana kawo fa'idodin gyare-gyaren daftarin aiki na ainihi da haɗin gwiwa zuwa babban adadin hanyoyin raba fayil, dandamali na e-learning, da tsarin sarrafa takardu.

A halin yanzu, yana dacewa da Moodle, Drupal, da sauran software. Haɗin kai yana yiwuwa ta hanyar haɗin da aka shirya don amfani waɗanda ke samuwa akan GitHub.

Yin amfani da Dokokin KAWAI, zaku iya aiki tare da duk shahararrun nau'ikan fayilolin ofis, gami da takaddun rubutu, maƙunsar bayanai, filaye masu cikawa, nunin faifai, da PDFs.

KAWAI Docs na asali shine OOXML (DOCX, XLSX, PPTX), don haka yana iya maye gurbin Microsoft Office cikin sauƙi akan injunan Linux. Wasu shahararrun tsarin, kamar ODF, ana tallafawa ta hanyar juyawa ta atomatik zuwa OOXML.

Baya ga sigar sa mai ɗaukar nauyi, KAWAI Docs yana da sigar girgije kyauta don amfanin mutum. Hakanan, akwai aikace-aikacen kyauta don duk mashahurin dandamali na tebur da wayar hannu, gami da Windows, macOS, Linux, Android, da iOS.

Idan ya zo ga aikin sarrafa kansa, KAWAI Dokokin ba su dace da macros na VBA na Microsoft ba. Yana amfani da macro na JavaScript waɗanda ke da ikon yin ayyuka iri ɗaya cikin mafi aminci.

Farawa da Macros don Dokokin KAWAI

Macro ƙaramin rubutun ne wanda ke sauƙaƙa aiki tare da nau'ikan takardu ta hanyar sarrafa wani aiki. A takaice dai, wani yanki ne na lambar shirye-shiryen da ke ƙunshe da tsarin ayyukan da za ku iya gudana akai-akai kamar yadda kuke so.

Misali, zaku iya gudanar da macro mai dacewa don haskaka kwafi a cikin yankin da aka zaɓa a cikin maƙunsar ku tare da launuka daban-daban.

A cikin Dokokin KAWAI, yayi kama da haka:

Menene amfanin wannan macro? Lokacin aiki tare da bayanai, zaku iya gudanar da macro da aka adana a cikin daƙiƙa ta danna madaidaicin maballin don haskaka ƙima mai kwafi kamar yadda kuke buƙata, wanda zai cece ku sa'o'i na lokaci.

A cikin Dokokin KAWAI, macros sun dogara ne akan tsarin tsarin JavaScript da hanyoyin API na Builder Document ONLYOFFICE. Akwai wasu dalilan da ya sa suka fi VBA macros:

  • Macro OFFICE KAWAI sune giciye-dandamali - Ba kamar Kayayyakin Kayayyakin Kaya ba, JavaScript shine yaren shirye-shirye gama gari. Saboda haka, macro na JavaScript na iya aiki cikin sauƙi akan Windows, Linux, da macOS.
  • Macro OFFICE KAWAI suna da sauƙin amfani - JavaScript galibi ana ba da shawarar ga masu farawa kuma yana da al'umma mai haɓaka cikin sauri. Mutane da yawa sun zaɓi JavaScript a matsayin yaren shirye-shiryen su na farko saboda akwai ɗimbin koyarwa da jagorori a Intanet.
  • Macro OFFICE KAWAI ba su da lafiya - Lambar JavaScript na macros KAWAI yana gudana a cikin taga iri ɗaya da masu gyara. Saboda haka, ba za a iya amfani da su don lalata tsarin ku ta hanyar masu kai hari ba saboda ba su da damar yin amfani da shi.

Macro KAWAI shine haɗe-haɗe na ƙa'idar JavaScript da hanyoyin API na Builder Document ONLYOFFICE.

ONLYOFFICE Document Builder shine ɗakin karatu na C ++ da ake amfani dashi don ƙirƙira da shirya fayilolin XML na Office da kuma adana fayilolin da ba na OOXML zuwa DOCX, XSLX, PPTX, da tsarin PDF ba. Yana aiki tare da JavaScript API.

Akwai hanyoyin API KAWAI KAWAI, kuma ba za ku iya amfani da yawancinsu ba. Waɗannan su ne wasu misalai masu amfani:

  • Hanyar SetFillColor an ƙera shi ne don canza launin bangon kewayon tantanin halitta zuwa launi na abin launi da aka ƙirƙira a baya.
  • Hanyar GetValue tana mayar da darajar kewayon kewayon.
  • Hanyar GetSlideByIndex tana mayar da zamewa zuwa matsayinsa a cikin gabatarwa.
  • Da dai sauransu.

Ana iya samun cikakken bayanin duk hanyoyin API KAWAI da abin da suke yi a cikin takaddun hukuma.

A cikin Dokokin KAWAI, ana iya ƙirƙira macros kuma share su ta hanyar plugin na musamman a saman kayan aiki na sama. Don samun dama gare shi, buɗe Plugins tab kuma danna maɓallin Macros. Za ku ga taga inda zaku iya rubuta lambar JavaScript don macros ɗin ku.

Yin amfani da maɓallan da suka dace, zaku iya ƙirƙirar sabbin macros kuma share waɗanda suke. Hakanan ana ba ku damar sake suna macros har ma kunna fasalin Autostart.

Yanzu da kuka fahimci yadda macros KAWAI ke aiki, bari mu rubuta ɗaya. Kafin mu fara, ya zama dole mu yanke shawarar irin aikin da za a yi tare da macro.

Bari mu fara da wani abu mai sauƙi kuma muyi tunanin cewa muna buƙatar canza launin bangon tantanin halitta a cikin takardar aikin mu na Excel. Wannan aikin guntun kek ne amma macro da za mu ƙirƙira zai sa ya fi sauƙi.

Don farawa, je zuwa Plugins shafin kuma danna Macros. Idan ka bude wannan taga a karon farko, zaku sami macro da aka riga aka ƙirƙira a wurin. Koyaya, ba za a sami lambar JavaScript a cikin wannan macro ba. Abin da za ku gani shine kunsa mai sauƙi:

(function()
{
    // ... your code here ...
})();

Sake suna macro na ku idan ya cancanta.

Yanzu zaku iya fara rubuta lambar ku. Bayan tuntuɓar takaddun ONLYOFFICE Document Builder API, wanda aka riga aka ambata a babin da ya gabata, zaku san cewa yakamata a yi amfani da waɗannan hanyoyin don macro ɗin ku:

  • Hanyar Api.GetActiveSheet don samun takardar aiki.
  • Hanyar GetRange don saita kewayon da ake buƙata.
  • Hanyar SetFillColor don saita launin bangon tantanin da ake buƙata.
  • The Api.CreateColorFromRGB don saita launi da ake so.

Da farko, kuna buƙatar samun takardar aiki kuma saita kewayon da ake buƙata ta hanyar buga hanyoyin da suka dace Bari mu nufa cell A2. Fara buga sunayen hanyoyin a cikin kayan aikin, kuma za ku ga duk kayan aikin da ake da su, wanda ya dace sosai.

Sannan, kuna buƙatar saita launin bangon tantanin halitta na yanzu. Don yin haka, yi amfani da hanyar SetFillColor. Hanyar Api.CreateColorFromRGBzai baka damar saita launin da kake so. Lambar ku yakamata ta kasance kamar haka:

(function()
{
    // Api.GetActiveSheet().GetRange("A2").SetFillColor(Api.CreateColorFromRGB(0, 0, 210));
})();

Yanzu lokaci ya yi da za a gudanar da macro kuma ganin sakamakon. Bayan danna maɓallin Run, za ku ga cewa tantanin halitta A2 yana da launi. Kuna iya yin wasa da launuka daban-daban ta canza darajar a cikin hanyar Api.CreateColorFromRGBhanyar.

Idan ba kwa son koyon abubuwan da ake buƙata na coding JavaScript don ƙirƙirar macros KAWAI, koyaushe kuna iya amfani da shirye-shiryen macro daga gidan yanar gizon hukuma kuma canza su gwargwadon bukatunku.

Kamar yadda kuke gani, ƙirƙirar macro a cikin Dokokin KAWAI ba shi da wahala kamar yadda ake gani a farkon gani. Tabbas, kuna buƙatar sanin tushen tushen coding na JavaScript don yin macro mai rikitarwa tare da layukan lamba da yawa.

Koyaya, ƙirƙirar macros masu sauƙi don ayyukan yau da kullun na yau da kullun baya buƙatar ku zama guru na JavaScript. Kuna iya koyan ƙa'idodi na asali yayin ƙoƙarin ƙirƙirar plugins ɗin ku.

Mahimmanci, ɗakin ofis ɗin ONLYOFFICE yana zuwa tare da cikakkun takaddun API da shirye-shiryen amfani da misalai don yin tsarin ƙirƙirar macros cikin sauƙi kamar yadda zai yiwu.