Skip to content

Style Workbook Cells

Description

Style cells inside of an excel file

Input Ports

Name dataType sourceType required description
File path text link-manual true The path to the excel file you want to read from
Sheet name text link-manual true The sheet name inside of the excel file you want to read from
Cell items data-list link-manual true he cells inside the sheet you want to style, must be a cell key value, eg. A1, B27
Cell style data-field manual-only true The options you want to style the cells with

Scenarios

  • The user wants to style targeted cells inside of an excel file

Use case

Command

Inputs
  • File path: C:/Users/admin/Desktop/example.xlsx
  • Sheet name: Sheet1
  • Fields: {a1; a2}
    Output
Experienced tips
  • If the file path value is empty, the process will stop and provide you with this error File not found
  • When the file path cannot be found, the process will stop and provide you with the error ENOENT: no such file or directory
Output

Output

Search Tags

get targeted cells from excel target cell