Count cells by color in excel with typescript

Question

I am trying to count cells by color in Excel with typescript. But I can't get the color back for cells that are in a range: Example:

let MyData = Mysheet.getRange("A1:C20").getFormat().getFill().getColor();

How to retrieve the color format for the cells in the range assuming they are empty?. I have tried trying to use for each statement to validate all cells, but it doesn't work with a string.

Thanks a lot

question from:https://stackoverflow.com/questions/65944573/count-cells-by-color-in-excel-with-typescript

Answer 1

Waitting for answers