nodes/generated

Interface MicrosoftExcelV1NodeParameters

Source


interface MicrosoftExcelV1NodeParameters {
    additionalFields?:
        | { name?: string }
        | { index?: number };
    dataProperty?: string;
    dataStartRow?: number;
    filters?: { fields?: string };
    keyRow?: number;
    limit?: number;
    lookupColumn?: string;
    lookupValue?: string;
    operation?:
        | "getAll"
        | "lookup"
        | "getColumns"
        | "getRows"
        | "addWorksheet"
        | "getContent"
        | "addRow";
    options?: { returnAllMatches?: boolean };
    range?: string;
    rawData?: boolean;
    resource?: "table" | "worksheet" | "workbook";
    returnAll?: boolean;
    table?: string;
    workbook?: string;
    worksheet?: string;
}

Properties§

§readonly additionalFields?: { name?: string } | { index?: number }

Default: {}

§readonly dataProperty?: string

The name of the property into which to write the RAW data Default: "data"

§readonly dataStartRow?: number

Index of the first row which contains the actual data and not the keys. Starts with 0. Default: 1 Type options: {"minValue":1}

§readonly filters?: { ... }

Default: {}

§readonly keyRow?: number

Index of the row which contains the keys. Starts at 0. The incoming node data is matched to the keys for assignment. The matching is case sensitve. Type options: {"minValue":0}

§readonly limit?: number

Max number of results to return Default: 100 Type options: {"minValue":1,"maxValue":500}

§readonly lookupColumn?: string

The name of the column in which to look for value

§readonly lookupValue?: string

The value to look for in column

§readonly operation?:
    | "getAll"
    | "lookup"
    | "getColumns"
    | "getRows"
    | "addWorksheet"
    | "getContent"
    | "addRow"

Default: "create"

§readonly options?: { ... }

Default: {}

§readonly range?: string

The address or the name of the range. If not specified, the entire worksheet range is returned. Default: "A1:C3"

§readonly rawData?: boolean

Whether the data should be returned RAW instead of parsed into keys according to their header

§readonly resource?: "table" | "worksheet" | "workbook"

Default: "workbook"

§readonly returnAll?: boolean

Whether to return all results or only up to a given limit

§readonly table?: string

Choose from the list, or specify an ID using an expression Type options: {"loadOptionsMethod":"getTables","loadOptionsDependsOn":["worksheet"]}

§readonly workbook?: string

Choose from the list, or specify an ID using an expression Type options: {"loadOptionsMethod":"getWorkbooks"}

§readonly worksheet?: string

Choose from the list, or specify an ID using an expression Type options: {"loadOptionsMethod":"getworksheets","loadOptionsDependsOn":["workbook"]}