Note that the recommended way to install pyxelrest is via the installer.
- Python >= 3.8 must be installed (with
pip
). - Use
pip
to install module:
python -m pip install pyxelrest
Once pyxelrest
python module is installed, pyxelrest_install_addin
executable is available to install the Microsoft Excel COM add-in.
- Microsoft Excel >= 2010 must be installed (Office 365 is supported).
- Microsoft .NET Framework >= 4.5.2 must be installed (Chances are that it is already installed).
- Within Microsoft Excel,
Trust access to the VBA project object model
should be enabled.File > Options > Trust Center > Trust Center Settings > Macro Settings
- Microsoft Excel must be closed while executing the following command:
pyxelrest_install_addin
Note: The add-in is not required if you only want to use pyxelrest
as a python module.
Name | Description | Possible values |
---|---|---|
check_pre_releases | Also fetch pre-releases when checking for updates. | No value is required, providing the option is enough. Prompt only for stable releases by default. |
source | Directory containing Microsoft Excel COM add-in (and optionally pyxelrest.xlam file). |
Default to pyxelrest_addin folder in the python executable data directory. |
vb_addin | Directory containing Microsoft Excel Visual Basic pyxelrest.xlam file. |
Default to pyxelrest.xlam within source folder. |
destination | Directory where add-in will be installed and add-in logs will be located. | Default to . folder (current location). |
trusted_location | Trusted Microsoft Excel location where visual basic add-in will be located. | Default to %APPDATA%\Microsoft\Excel\XLSTART folder. |
Note: option name must be prefixed with --
such as:
pyxelrest_install_addin --check_pre_releases
- Go to
Control Panel/Programs and Features
and uninstallPyxelRestAddIn
. - Execute the following command:
python -m pip uninstall pyxelrest
- Remove the
destination
folder provided at add-in installation. - Remove
pyxelrest.xlam
file within thetrusted_location
folder provided at add-in installation. - Remove
HKEY_CURRENT_USER
Software\Microsoft\Windows\CurrentVersion\Uninstall\PyxelRest
registry key.