如何定义行颜色Excel [英] How define row color Excel

问题描述

int rows = darray.GetUpperBound(0);
int cols = darray.GetUpperBound(1);
for (int i = 1; i <= rows; i++)
{
    for (int j = 1; j <= cols; j++)
    {
        workSheet_range = mySheet.get_Range(i, j);
        if (workSheet_range.Interior.Color == System.Drawing.Color.Red)
        {
             kauntalda++;
        }
    }
}

推荐答案

//....
workSheet_range = mySheet.get_Range(i, j); 
if(workSheet_range.Interior.Color == System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red)
{
// your stuff goes here
}
/....

要获取或设置单元格背景的颜色，可以使用ColorIndex [

To get or set a color for cell background, you can use ColorIndex[^] property too.

//chack for white
if(workSheet_range.Interior.ColorIndex == 2)
{
// ... ;)
}

这篇关于如何定义行颜色Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！