Login

Load data from Excel (XLSX) Last updated: 20. Dec 2022

Example of how to load data from an Excel file and use it in your site.

LoadExcel(filename, column, row, sheet)

Loads data from excel file. First row must contain the headers.

Parameter

Type

Required

Description

filename

string (filepath)

yes

Absolute file path for Excel file (XLSX) to load data from.

column

number

no

Column to start loading from (counting from 1)
Default 1

row

number

no

Row to start loading data from (counting from 1)
Default 1

sheet

number

no

Sheet number (counting from 1)
Default 1

Example loading data to HTML-page

This example code loads data from an excel file:

<h1>Product list</h1>
<table>
    <thead>
    <tr>
        <td>Number</td>
        <td>Name</td>
        <td>Price</td>
    </tr>
    </thead>
    <tbody>
    #var xlsx = docly.loadExcel("Test files/Example file.xlsx")#
    #for(var row of xlsx) {#
    <tr>
        <td>#row.Number#</td>
        <td>#row.Name#</td>
        <td>#format(row.Price, "N")#</td>
    </tr>
    #}#
</tbody>
</table>

Contents of Excel (Example file.xlsx) file: