- Microsoft Excel Wizard does not show any parameter
- Microsoft Excel Wizard only list some functions
- No command specified in the configuration, cannot autostart server
- Microsoft Excel COM Add-In cannot be installed
- Dates with a year higher than 3000 are not converted to local timezone
- Python process exited before it was possible to create the interface object
- pyxelrest.xlam is not available
- Can I install xlwings and pyxelrest?
Microsoft Excel function wizard is not able to handle functions with a long definition.
The total length of parameter names (and commas to separate them) should not exceed 253 characters,
In case it does (your UDF has a lot of parameters or parameters with long names), then Microsoft Excel is unable to display them all in the function wizard.
To overcome this Microsoft Excel limitation you can try the following:
- Exclude some parameters.
- Remove some parameters in your service (in case you manage the service yourself).
- Reduce the length of your service parameter names (in case you manage the service yourself).
Microsoft Excel function wizard is not able to list more than a certain amount of functions per category.
However, all functions can be directly accessed in cells.
To overcome this Microsoft Excel limitation you can try the following:
This error will happen in case you manually specified in your xlwings.bas file to use debug server but did not uncomment the main function starting the server on pyxelrest module side.
Check that all requirements are met:
- Microsoft .NET Framework >= 4.5.2 must be installed.
- Microsoft Visual Studio 2010 Tools for Office Runtime must be installed.
In case you encounter an issue like Could not load file or assembly 'Microsoft.Office.BusinessApplications.Fba... anyway, you then need to remove C:\Program Files\Common Files\Microsoft Shared\VSTO\10.0\VSTOInstaller.exe.config file.
In case you encounter an issue like ...An application with the same identity is already installed..., you then need to manually remove all folders within %USERPROFILE%\AppData\Local\Apps\2.0 and restart your computer.
Due to timestamp limitation, dates after 3000-12-31 and date time after 3001-01-01T07:59:59+00:00 cannot be converted to local timezone.
You need to check log files to identify the underlying issue.
The add-in might be disabled.
Within Microsoft Excel, go to File/Option/addin and check disabled items (Manage: Disabled Items)
Yes.
We advise installing pyxelrest in its own virtual environment.
As pyxelrest relies on xlwings, if you want to use xlwings you can, but if you rely on some specific xlwings configuration, you should use a separate environment.
The pyxelrest add-in and xlwings add-in can be installed for the same user as long as pyxelrest is installed in a separate virtual environment.
Those icons come from iconsdb.
The blue color set is #00AAFF, the grey color set is #CDCACD and the orange one is the orange set from iconsdb.