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.   

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

  2.   

    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;
                        }
                    }
      

  3.   


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