79360006

Date: 2025-01-15 23:43:55
Score: 2.5
Natty:
Report link

@taller, thank you, exactly what I was looking for!!!

function get_colors(dataRange: ExcelScript.Range) {
    let arrayResult: Object[] = []
    let colCnt = dataRange.getColumnCount()
    for (let colIdx = 0; colIdx < colCnt; colIdx++) {
        let arrayRow: String[] = []
        let col = dataRange.getColumn(colIdx)
        let rowCnt = col.getRowCount()
        for (let rowIdx = 0; rowIdx < rowCnt; rowIdx++) {
            // console.log(row.getColumn(colIdx).getFormat().getFill().getColor())
            arrayRow.push(col.getRow(rowIdx).getFormat().getFill().getColor())
        }
        arrayResult.push(arrayRow)
    }
    return arrayResult
}

Reasons:
  • Blacklisted phrase (0.5): thank you
  • Long answer (-0.5):
  • Has code block (-0.5):
  • User mentioned (1): @taller
  • Looks like a comment (1):
  • Low reputation (1):
Posted by: Starfield Screensaver