/** * Microsoft Excel Node - Version 1 * Discriminator: resource=table, operation=getRows */ interface Credentials { microsoftExcelOAuth2Api: CredentialReference; } /** Represents an Excel table */ export type MicrosoftExcelV1TableGetRowsParams = { resource: 'table'; operation: 'getRows'; /** * Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> */ workbook?: string | Expression; /** * Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> */ worksheet?: string | Expression; /** * Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a> */ table?: string | Expression; /** * Whether to return all results or only up to a given limit * @default false */ returnAll?: boolean | Expression; /** * Max number of results to return * @displayOptions.show { returnAll: [false] } * @default 100 */ limit?: number | Expression; /** * Whether the data should be returned RAW instead of parsed into keys according to their header * @default false */ rawData?: boolean | Expression; /** * The name of the property into which to write the RAW data * @displayOptions.show { rawData: [true] } * @default data */ dataProperty?: string | Expression | PlaceholderValue; /** * Filters * @displayOptions.show { rawData: [true] } * @default {} */ filters?: { /** Fields the response will containt. Multiple can be added separated by ,. */ fields?: string | Expression | PlaceholderValue; }; }; export type MicrosoftExcelV1TableGetRowsNode = { type: 'n8n-nodes-base.microsoftExcel'; version: 1; credentials?: Credentials; config: NodeConfig; };