A. the Macro should be written in Python;
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. 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]": copy to the cells A2, B2, C2)
.
.
.
.
.
.
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
Hi there As I have read your requirements I could do this for you Effective and Efficiently .So I could make it best for you .so you can leave a massage on chat to discuss it further.
Relevant Skills and Experience
I am new to this platform but I have four years experience in Data Entry,Data Processing,Execl,Data Base SQL.I have also developed two iOS app but they are not yet on app store.
Hi,I have read your requirements of Python Macro / Script for LibreOffice Calc and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can reach me at any time on online .
I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility.
kind regards.