CreateTableFromWorkbook

Overview

Create and load a new table from a worksheet in an Excel workbook.

Use

Accessed through Script Editor Menu->Import Data->Excel File

Browse for the workbook via the file icon, once loaded a list of available worksheet will fill the combo box.

Select the required worksheet and loaded table name.

You can optionally set the header start row and start and end rows to load. The default value for start and end rows is 0, this will load all available rows.

Tip:

If your workbook is not already on the server, upload it with the Remote File manager (Menu->Admin->Remote Files)

{
  "method": "CreateTableFromWorkbook",
  "action": "LOAD",
  "table": "mytable",
  "filename": "%DATAPATH%/a.xlsx",
  "worksheet": "Index",
  "headerRow": 1,
  "startRow": 0,
  "endRow": 0,
  "ignoreEmptyRows": true
}

4.2.15.2

Added optional worksheetRowName key.

{ "worksheetRowName" : "OriginalRow" }

If present will add a field with that name containing the loaded worksheet rows

4.3.31.1

Added optional filenameColumn key. 

Implemented action="APPEND" 

Specify initial minimum discrete field size with key "minDiscreteSize": 1[2 or 4]