Help:Excel format

Jump to: navigation, search
Excel format
Outputs the result in Microsoft Office Excel file format (xls).
Further Information
Provided by: Semantic Result Formats
Added: 1.9.0
Removed: still supported
Requirements: "PHPExcel" library (handled by Composer)
Format name: excel
Indicates whether the result format is enabled by default upon installation of the respective extension.
Authors: Kim Eik
Categories: export
Table of Contents
The underlying PHPExcel library was deprecated and replaced by the PHPSpreadsheet library which is not yet supported by this result format. You are advised to no longer use this result format until it supports the new library. See the respective issue report1 for progress on this.

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 extension "Semantic Result Formats"Provides additional formats for semantic queries this format will automatically be available if the required PHPExcel library is installed.


A fatal error occurred in the #smwdoc parser function


This result format is not available on this wiki. Thus an example output cannot be provided.
 [[located in::Germany]] 
 |?Area#km² = Size in km²
 |searchlabel=Download result as xls-file for MS Excel


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:

"phpoffice/phpexcel": "~1"

Now run the following command from the root directory of your wiki to complete the installation:

composer update --no-dev


  1. ^  Semantic Result Formats: GitHub issue gh:srf:382