Skip to content

Feature request: Specify key column and variable columns separately #2

@cognifloyd

Description

@cognifloyd

Please let me set the variable start and end columns separately from the key_column.

There's a spreadsheet that I don't maintain or produce. I need to look up values in columns A-I from that spreadsheet based on column J (key_column=10). However, actions as they are assume that the key_column comes first, and variable columns follow. So, with the current implementation I can only look up values in columns K+.

Currently the code sets _variable_start_column to key_column + 1 and then looks for the next cell in the header row that is blank, and sets _variable_end_column to one less than that blank column.

It shouldn't be too much work to add two more parameters variable_start_column and variable_end_column, and use those if they are set instead of the current logic.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions