Python Pyoo based script to find the unique elements in a librecalc column

The following is pyoo based python script will be able to list all the unique values in a given column of a librecalc. For example if we have the following file

If we want to find all the unique terms in the column num, just run the following script. Ensure that the path variable is initialized to the full path pointing to the librecalc file.  The script requires pyoo installed, the steps for which are listed here.

Before running the script, make sure to run the following command.

soffice --accept="socket,host=localhost,port=2002;urp;" --norestore --nologo --nodefault



Saved the script as unique_items.py, and execute it. For the above example file shown, we get the following output.

Enter the column header for unique elements are needed num There are 7unique values 1 2 3 4 5 6 7