Programming
Users of this site typically use Excel/VBA or LibreOffice/Python for processing financial data. This page gathers together various bits of information about programming with these tools.
LibreOffice/Python
LibreOffice (and OpenOffice have built-in editors and interpreters for Basic. Although this works, some of the code is complicated and performance is often very poor. Almost any language can be used with LibreOffice, such as Java, Python and Javascript. Python is probably the most common and easiest to implement. The following documents will hopefully help a Python programmer to build code for use with LibreOffice.
LibreOffice and OpenOffice are very similar, so the documents will generally apply to both. However, it should be noted that LibreOffice uses Python 3.3 and OpenOffice uses Python 2.7. Although these are very similar, it may be necessary to implement some code to detect the Python version and adapt script behaviour to enable a macro to work in both LibreOffice and OpenOffice.
LibreOffice and OpenOffice are very similar, so the documents will generally apply to both. However, it should be noted that LibreOffice uses Python 3.3 and OpenOffice uses Python 2.7. Although these are very similar, it may be necessary to implement some code to detect the Python version and adapt script behaviour to enable a macro to work in both LibreOffice and OpenOffice.
This LibreOffice Writer document describes how to run a Python macro which is external to LibreOffice, and also how to embed the Python macro within a LibreOffice document.
|
|
This text document lists some python code structures to read and write to cells in LibreOffice, format cells, create message boxes, etc
|
|