ExcelAutomat for Excel

Installation of ExcelAutomat for Excel

1. Download ExcelAutomat for Excel to local folder.

2. Open ExcelAutomat in Excel.

3. Macros may need to be enabled (link).

Adding WinSCP reference

1. Install WinSCP reference .NET assembly (link1, link2).

Configuring ExcelAutomat for cclib

1. Install cclib in python (link).

2. Ensure "ExcelAutomat.py" from the download folder is in the same location as ExcelAutomat.

Custom Coding

1. Show the developer tab (link).

ExcelAutomat for LibreOffice

Installation of ExcelAutomat for LO

1. Download ExcelAutomat for LibreOffice to local folder.

2. Open ExcelAutomat in LO.

3. Macros may need to be enabled (link).

Configuring ExcelAutomat for cclib in LO 5.3.

1. Navigate to the LO installation folder. (e.g."C:\Program Files (x86)\LibreOffice 5")
2. Copy python33.dll from 'LO installation folder\program' to LO 'installation folder\program\python-core-3.3.0\bin'. (e.g. "C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\bin")
3. Copy ExcelAutomat.py from the LibreOffice download folder to 'LO installation folder\share\Scripts\python'. (e.g. "C:\Program Files (x86)\LibreOffice 5\share\Scripts\python")
4. Install cclib in the LO built-in python found at 'installation folder\program\python-core-3.3.0\bin'.

(a) Download and extract cclib (in any folder).

(b) In command prompt or terminal, navigate to within the extracted folder. The folder should contain "setup.py".

(c) Run the following command: linktopythonexe setup.py build (press enter). (e.g. "C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\bin\python.exe" setup.py build) May need to initiate command prompt with administrator privileges.

(d) Run the following command: linktopythonexe setup.py install (press enter). (e.g. "C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\bin\python.exe" setup.py install)

Note on how to get linktopythonexe path: Navigate to 'installation folder\program\python-core-3.3.0\bin', shift+right mouse click the python executable and select copy as path.