Using the LibreOffice app in Python (1) Where are the macros?

I think we're in an era where small desktop apps that handle data will come in handy, but what about everyone?

What I have in mind now is a tool for checking setting information such as server settings. Check phpinfo to see if the settings are correct. Then, create a JSON file for AWS settings.

I'm thinking of making a desktop application that does these tasks using LibreOffice and python. We plan to make it cross-platform.

The reason for using libreoffice is to save you the trouble of creating the user interface part. So, if the language is python, java is a little heavy, so I chose python as a handy language. It's also a data mining language, and it's good to be able to use it on AWS and fabric. I'm confused about the version, but it's based on 2.7. libreoffice will be 3 series, but it can not be helped.

* Where are the macros? *

Let's start by writing the macro in python. The first thing that stumbles is where the macros are stored. For the time being, it is the result of investigation.

windows 7 LibreOffice 5.0.3 AppData is a hidden file, so it's useful to have it visible in the folder options. ** Self-made macro ** C: \ Users \ username \ AppData \ Roaming \ LibreOffice \ 4 \ user \ Scripts \ python ** Sample macro ** C:\Program Files (x86)\LibreOffice 5\share\Scripts\python

ubuntu14.04 It seems that the directory changes depending on the LibreOffice 5.0.3.2-2 package.

** Self-made macro ** /home/username/.config/libreoffice/4/user/Scripts/python ** Sample macro ** /opt/libreoffice5.0/share/Scripts/python

OSX10.9.5  LibreOffice 5.0.3 ** Self-made macro ** / Users / username / Library / Application Support / LibreOffice / 4 / user / Scripts / python ** Sample macro ** /Applications/LibreOffice.app/Contents/Resources/Scripts/python

Recommended Posts

Using the LibreOffice app in Python (1) Where are the macros?
Use the LibreOffice app in Python (3) Add library
Use the LibreOffice app in Python (2) Manipulate calc (from macros and externals)
Try using the Wunderlist API in Python
Try using the Kraken API in Python
Tweet using the Twitter API in Python
Check if the characters are similar in Python
Pre-process the index in Python using Solr's ScriptUpdateProcessor
Operate the schedule app using python from iphone
Try using the DropBox Core API in Python
[AWS IoT] Register things in AWS IoT using the AWS IoT Python SDK
Initial settings when using the foursquare API in python
Determine the threshold using the P tile method in python
Using the National Diet Library Search API in Python
Working with LibreOffice in Python
Download the file in Python
Find the difference in Python
Translate using googletrans in Python
Using Python mode in Processing
Make sure all the elements in the list are the same in Python
Solve the Japanese problem when using the CSV module in Python.
(Python3) No. oO (Are you using the standard library?): 5 shaders
If you think that the person you put in with pip doesn't work → Maybe you are using python3?
GUI programming in Python using Appjar
Precautions when using pit in Python
python Note: Determine if command line arguments are in the list
Python in the browser: Brython's recommendation
Save the binary file in Python
Hit the Sesami API in Python
Python beginners tried Hello World in 30 seconds using the micro-framework Flask
Get the desktop path in Python
Automatically resize screenshots for the App Store for each screen in Python
Put the module in the Pepper app
python: Use the variables defined in the string format as they are
Try using LevelDB in Python (plyvel)
Get the script path in Python
In the python command python points to python3.8
Implement the Singleton pattern in Python
Using global variables in python functions
Hit the web API in Python
Let's see using input in python
Infinite product in Python (using functools)
Edit videos in Python using MoviePy
I wrote the queue in Python
Examine the object's class in python
Get the desktop path in Python
Try using the Python Cmd module
Get the host name in Python
Handwriting recognition using KNN in Python
Access the Twitter API in Python
Try using Leap Motion in Python
The first step in Python Matplotlib
Depth-first search using stack in Python
When using regular expressions in Python
I wrote the stack in Python
Try using FireBase Cloud Firestore in Python for the time being
Master the weakref module in Python
GUI creation in python using tkinter 2
Create a record with attachments in KINTONE using the Python requests module
A useful note when using Python for the first time in a while
Move the turtle to the place where you click the mouse with turtle in Python