Sheets to Tables
To convert a spreadsheet file into an HTML <table>
, pass an craft\elements\Asset object as an argument to the sheetstotables(asset)
Twig function.
{% set spreadsheet = craft.assets.kind('excel').one() %}
{{ sheetstotables(spreadsheet) }}
If the spreadsheet file contains multiple sheets, only the contents of the first sheet will be rendered as a table.
Supported file formats
- CSV
- Excel (.xlsx, .xls)
- Open Document Format (.ods)
- Other formats supported by PhpSpreadsheet
Free
Package Name
To install this plugin, search for its package name on the Plugin Store and click “Install”.