Table of Contents

Data Resource - Excel

About

xlsx or xls are supported tabular file data resource.

Attributes

An excel file has the following attributes.

Name Default Value Description
headerRowId 0 The row id where the header is located (0 means no header and 1 the first line)
sheetName The sheet name (Optional, first sheet by default)
dateFormat dd/mm/yyyy hh:mm:ss The date format (ie Format Cells > Number > Custom)

In Excel, dates are numeric cell with an applied date format.