ojob.io/formats/fromXLS

Usage

ojob ojob.io/formats/fromXLS file=file.xlsx sheet=Sheet1 evalFormulas=false column=A row=1 

Description

Given an excel sheet will try to convert it into an array of maps

Expects

Name Description
file The source XLS file
sheet The name or number of the XLS sheet to extract data from (defaults to the first)
evalFormulas If formulas should be evaluated when extracting data (defaults to false)
column The column where the data extraction should start (default to 'A')
row The row where the data extraction should start (default to 1)