ojob ojob.io/formats/fromXLS file=file.xlsx sheet=Sheet1 evalFormulas=false column=A row=1
Given an excel sheet will try to convert it into an array of maps
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) |