Help:Spreadsheet format

The result format spreadsheet 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 e.g. MS Excel or LibreOffice Calc, however values could be wrongly interpreted as numbers when they were in fact strings. This format fixes that issue. It was introduced with version 3.1.0 of and replaces the recursing CiteRef::gh:srf:382.

This format will automatically be available if the required PhpSpreadsheet library is installed. {{#if: {{#smwdoc:spreadsheet}} |

Parameters
}}

Example 1
Query without using result format specific parameters.


 * Syntax


 * Result

Example 2
Query using result format specific parameters.


 * Syntax


 * Result

Installation
This section describes how to install the required PHPSpreadsheet library with Composer. To do this add the following as the last line of the "require" section in your "composer.local.json" fileCiteRef::semantic-mediawiki.org:composer.local.json 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: