Login to follow
ExcelColoring

ExcelColoring (ODC)

Stable version 0.1.2 (Compatible with ODC)
Uploaded on 30 Jan by EONE TECHNOLOGIES PRIVATE LIMITED
ExcelColoring

ExcelColoring (ODC)

Documentation
0.1.2

Action 1: ColorSpecificCells

Purpose: Color individual cells specified in a CSV list

Parameters:

  • excelFileBinary (Binary Data) - Your Excel file
  • cellReferencesCsv (Text) - CSV list like "A1,B2,Z7,AA10"
  • colorHex (Text) - Hex color like "#FF0000" or "FF0000"
  • sheetName (Text, Optional) - Sheet name, leave empty for first sheet

CSV Format Options:

  • Comma-separated: "A1,B2,C3"
  • Semicolon-separated: "A1;B2;C3"
  • Mixed: "A1, B2; C3"

-----------------------------------------------------------------

Action 2: ColorRowsOrColumns

Purpose: Color entire rows or columns

Parameters:

  • excelFileBinary (Binary Data) - Your Excel file
  • rowsOrColumns (Text) - CSV like "Row:1,Row:5,Column:A,Column:C"
  • colorHex (Text) - Hex color like "#00FF00" or "00FF00"
  • sheetName (Text, Optional) - Sheet name
  • colorOnlyUsedCells (Boolean) - True to color only cells with values

Specifications:

  • Rows: "Row:1", "Row:5", "Row:100"
  • Columns: "Column:A", "Column:Z", "Column:AA"
  • Mixed: "Row:1,Row:3,Column:A,Column:B"

-----------------------------------------------------------------

Action 3: ColorCellsByText

Purpose: Color all cells containing specific text

Parameters:

  • excelFileBinary (Binary Data) - Your Excel file
  • searchText (Text) - Text to search for
  • colorHex (Text) - Hex color like "#FF0000"
  • sheetName (Text, Optional) - Sheet name
  • exactMatch (Boolean) - True for exact match, False for partial
  • caseSensitive (Boolean) - True for case-sensitive search

Search Options:

  • Partial match: Finds "Error" in "System Error"
  • Exact match: Only finds cells with exactly "Error"
  • Case-sensitive: Distinguishes "error" from "Error"