Hub
ComponentComponent

XLS Cell Validation (apply)

XLSXLSXExcelCellFormat
+4
mccr profile image
Draft Latest edits on 
Drag & drop
Like
Use or download
KNOWN ISSUE: this node cannot overweite existing cell validations. This node adds cell validations to XLS and XLSX document files. It is implemented with Apache POI library.

Component details

  • Text length

    Enter Description

  • List of values

    Enter Description

  • Path to .xlsx/.xls file (execute node after file selection to see list of sheets)

    Enter a valid path to the excel file within which a cell validation should be applied

  • Sheet selection (execute node after file selection to see list of sheets)

    Select sheet to which you want to apply the validation

  • Validation Cell Range

    Enter Description

  • Validation Type (execute node after selection to see appropriate configuration options!)

    Enter the type of validation that you want to apply to the cell range.

  • Maximum value (decimal)

    Enter Description

  • Minimum value (decimal)

    Enter Description

  • Maximum value (whole number)

    Enter Description

  • Minimum value (whole number)

    Enter Description

Used extensions & nodes

This component does not have nodes, extensions, nested components and related workflows