Closed

Python Macro / Script for LibreOffice Calc

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

Skills: Data Entry, General Office, JSON, Python, Software Architecture

See more: macro script, excel macro script reference, python csv script, libreoffice uno python, libreoffice serial port, how to open libreoffice using python, libreoffice basic, libreoffice calc call macro, running macros in libreoffice, openoffice calc macro examples, python libreoffice base, macro script vba, macro excel 2003 calc, python auction script, macro script add text file, macro script excel, macro script update database excel, excel top ten macro script visual basic, basic macro script, forward email outlook macro script

About the Employer:
( 9 reviews ) Essen, Germany

Project ID: #19038833

3 freelancers are bidding on average $25 for this job

monirnasrin

With over 2 year of experience I can work data entry job. Hire me if you like to have your work done with complete precision, accuracy & deadlines……..

$25 USD in 1 day
(0 Reviews)
0.0
abidiop3332

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 More

$25 USD in 1 day
(0 Reviews)
0.0
VishalAgrawal11

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 discu More

$24 USD in 2 days
(0 Reviews)
0.0