Help:Excel format

The result format excel is used to format query results as a spreadsheet. It is similar to the csv format except that value types are now explicitly handled. Previously one could export to csv and then import to excel, however values could be wrongly interpreted as numbers when they were in fact strings. This format fixes that issue.

Since version 1.9.1 of this format will automatically be available if the required PHPExcel library is installed.

It was removed with version 3.1.0 of. {{#if: {{#smwdoc:excel}} |

Parameters
}}

Example

 * Syntax

Installation
This section describes how to install the required PHPExcel library with Composer. To do this add the following as the last line of the "require" section in your "composer.local.json" file not forgetting to add a comma to the end of the preceding line: Now run the following command from the root directory of your wiki to complete the installation: