Skip to main content

ExcelDescriptor

match_onstring[]required
columns objectrequired
property name*string
computed_columns object
property name* ComputedColumn
modeMode (string)required

Possible values: [combine, regex]

fieldsstring[]required
separator object
anyOf
string
regex object
anyOf
string
type_casts object
property name*string
defaults object
property name*string
photos object
anyOf
fieldField (string)
Default value: photos
sub_field object
anyOf
string
suffix object
anyOf
string
formatFormat (string)required
excel_params objectrequired
sheet_name object
anyOf
string
skiprows object
anyOf
integer
header object
anyOf
integer
usecols object
anyOf
string
skipfooter object
anyOf
integer
dtype object
anyOf
object
na_values object
anyOf
  • Array [
    • string
  • ]
    • ExcelDescriptor
    {
      "match_on": [
        "string"
      ],
      "columns": {},
      "computed_columns": {},
      "type_casts": {},
      "defaults": {},
      "photos": {
        "field": "photos",
        "sub_field": "string",
        "suffix": "string"
      },
      "format": "string",
      "excel_params": {
        "sheet_name": "string",
        "skiprows": 0,
        "header": 0,
        "usecols": "string",
        "skipfooter": 0,
        "dtype": {},
        "na_values": [
          "string"
        ]
      }
    }