amr users plus as of version 3.6 includes the ability to offer a direct excel export of the user list data, instead of, or as well as the .csv export.
Similar to the existing .csv option, in general settings one can set the icon or text for the export link at the bottom of the lists. See excel wordpress user export demo.
The CSV filter (export of filtered list) will offer buttons for CSV export and XLS export.
The functionality requires php 7.1 or higher and that phpoffice/phpspreadsheet library be accessible on the server. See
- https://www.smashingmagazine.com/2019/03/composer-wordpress/ and
Using composer, it looks first for:
and requires that if found. If that is not found, then it looks for
The plugin https://github.com/codeboxrcodehub/cbxphpspreadsheet just needs to exist in wordpress, it does not need to be active. The plus plugin will check for it’s code and load if found.
XLS export will not function if phpspreadsheet and writer class is not found.