for (int row = 1; row <= 35; row++)
                {
                    if ((row + 1) % 2 == 0)
                    {
                        objWorkSheet.get_Range("A" + row, "Z" + row).Interior.Color = 255;
                    }                    else
                    {
                        objWorkSheet.get_Range("A" + row, "Z" + row).Interior.Color = 200;
                    }
                }希望高手指点。感激不尽!!

解决方案 »

  1.   

    for (int row = 1; row <= 35; row++)
                    {
                        if (row % 2 == 0)
                        {
                            objWorkSheet.get_Range("A" + row, "Z" + row).Interior.Color = 255;
                        }                    else
                        {
                            objWorkSheet.get_Range("A" + row, "Z" + row).Interior.Color = 200;
                        }
                    }
      

  2.   

    row一定要等于0的话 怎么写?
      

  3.   

    不一定要用row % 2 == 0这种方法判断奇数偶数 只要row能做到以0开始就OK
      

  4.   

    for (int row = 0; row <= 34; row++)
                    {
    row++;
                        if ((row + 1) % 2 == 0)
                        {
                            objWorkSheet.get_Range("A" + row, "Z" + row).Interior.Color = 255;
                        }                    else
                        {
                            objWorkSheet.get_Range("A" + row, "Z" + row).Interior.Color = 200;
                        }
    row--;
                    }