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
***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 developer, I believe my skills and talents can make a great result and a long-term contribution to you.
With over 10 years of development experience including graphic design and programming,
I would enjoy helping you with your project.
Promise high-quality and shortest time.
You'd like to discuss how my creativity and experience can benefit your project.
I look forward to your reply.
Thank you for your time and attention.
Sincerely.
Best Srvice.
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 I do it independently and produce csv script for you. The reason I am asking is all you are looking for is the output CSV there might be a better way to do it. Can be done in whichever way you prefer.