Suljettu

Looking for a LibreOffice Javascript Macro/Script

A. the Macro should be written in Javascript;

B. the Macro should be run on LibreOffice Calc;

C. The Macro should loop the follows Step 1 to Step 3 every 30 minutes

Step 1. get the first empty cell in column C, the row number of the first empty cell in column C is n(we will use this number n in step 3). For example, if C107 is not empty and C108 is empty, then C108 is the first empty cell in column C and n is 108;

Step 2. Using function [login to view URL]() to get the second pet name to the first empty cell in column C from the following URL:

[login to view URL]

Explanation of the above URL:

[login to view URL]

[login to view URL]

Step 3. create a CSV file and named as "[login to view URL]", copy the contents of the following cells to the CSV file, and save the CSV file to the same folder of the LibreOffice Calc file. If the CSV file [login to view URL] existed in this folder, then replace it.

A1, C1, D1 (copy to the first row of the CSV file "[login to view URL]", copy to the cells A1, B1, C1)

A(n-100), C(n-100), D(n-100) (copy to the second row of the CSV file "[login to view URL]")

.

.

.

.

.

.

A(n-3), C(n-3), D(n-3) (copy to the 99th row of the CSV file "[login to view URL]")

A(n-2), C(n-2), D(n-2) (copy to the 100th row of the CSV file "[login to view URL]")

A(n-1), C(n-1), D(n-1) (copy to the 101th row of the CSV file "[login to view URL]")

An, Cn, Dn (copy to the 102th row of the CSV file "[login to view URL]")

which n is the number of the first empty cell in column C in step 1, (n-1) = n-1, (n-2) = n-2, ......, (n-100) = n-100

Taidot: Javascript, jQuery / Prototype, JSON

Näytä lisää: libreoffice basic, running macros in libreoffice, libreoffice serial port, libreoffice uno commands, javascript macro example, libreoffice http api, libreoffice basic vs vba, libreoffice api java example, macro script, javascript required script, excel macro script reference, javascript pop script wordpress, macro script vba, macro script add text file, script auto save sametime chats, macro script excel, macro script update database excel, javascript snowflakes script, javascript search script jsp servlets, looking good help desk script

Tietoa työnantajasta:
( 9 arvostelua ) Essen, Germany

Projektin tunnus: #19038527

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

Vadimwang

***BUG-FREE**PERFECT SERVICE** Dear. Thank you for your job post. I have read your job description carefully just before. I am very interested in your project and eagerly want to work with you. As an experienced Lisää

$35 USD 1 päivässä
(6 arvostelua)
3.1
artinem

I have extensive experience in excel scripting, JSON and JSON parsing with javascript/python. I understand that you require a libre CALC script but just to clarify is it mandatory that I do it in Libre CALC or can Lisää

$25 USD 3 päivässä
(0 arvostelua)
0.0