Add Data Validation ​

Function Description ​

TIP

Add Data Validation

Add Data Validation

Configuration Item Description ​

General ​

Command Input

  • Excel InstanceTWorkbookApplication: Enter an Excel instance obtained by the functions 'Open or New Excel'/'Get Active Excel Instance'

  • Allow TypeInteger: Allow Type

  • Ignore Null ValuesBoolean: If checked, null values will be ignored

  • Provide Dropdown ArrowBoolean: Provide Dropdown Arrow

  • Data TypeInteger: Select data calculation method

  • Minimum ValueInteger: Minimum Value

  • Maximum ValueInteger: Maximum Value

  • Sourcestring: Source

  • Start Datestring: Start Date

  • End Datestring: End Date

  • Start Timestring: Start Time

  • End Timestring: End Time

  • Formulastring: Formula

  • Region TypeInteger: Select the range for data validation

  • Unit Row NumberInteger: Enter the line number, starting from 1, -N represents the nth to last row

  • Unit Column Namestring: Enter the column name, starting from A or 1, -N represents the nth to last column

  • Start Row NumberInteger: Enter the line number, starting from 1, -N represents the nth to last row

  • Start Column Namestring: Enter the column name, starting from A or 1, -N represents the nth to last column

  • End Row NumberInteger: Enter the line number, starting from 1, -N represents the nth to last row

  • End Column Namestring: Enter the column name, starting from A or 1, -N represents the nth to last column

  • Row NumberInteger: Enter the line number, starting from 1, -N represents the nth to last row

  • Column Namestring: Enter the column name, starting from A or 1, -N represents the nth to last column

  • Sheet Namestring: Worksheet name

Command Output

No output for the current command

Advanced ​

  • Delay Before(milliseconds)Integer: The waiting time before instruction execution

Error Handling ​

  • Print Error LogsBoolean: Whether to print error logs to the "Logs" panel when the command fails. Default is checked.

  • Handling MethodInteger:

    • Terminate Process: If the command fails, terminate the process.

    • Ignore Exception and Continue Execution: If the command fails, ignore the exception and continue the process.

    • Retry This Command: If the command fails, retry the command a specified number of times with a specified interval between retries.

Usage Example ​

Process logic description:

Common Errors and Handling ​

None

Frequently Asked Questions ​

None