integrates python into any office app!
python should be available in office, in its fullest form:
- open a python window with the click of a button ✔️
- to accelerate this software, code will be written into C++.
- this library will function like an API between python and office/libreoffice.
- call VBA functions from python and access VBA fields ✔️
- call python functions from VBA and f.e. excel values ✔️
we'll have a marketplace containing opyce scripts, to get started easily.
- when clicking on the python button on office, a new window, containing a python interpreter, will pop up. the files it contains will be in the temp folder. ✔️
- when saving the excel document, the python files will be saved inside of the document. ✔️
- the window could be a VSCode window. the python interpreter will be downloaded as recommended extension. ✔️
to share data between addins, we can:
- write an ini file which the main application will read. the ini file will store the current code. ✔️
https://learn.microsoft.com/en-us/office/dev/add-ins/outlook/one-outlook
#for python script execution buttons to office, see https://www.youtube.com/watch?v=N7Gqet9FSjA&list=PLHnSLOMOPT11njaNmENJN6p2ro9MTc7t_&index=14