怎么用Microsoft.Office.Interop.Excel来实现隔行染色呢？

[CypressXT]

private void excelParsing()
        {
            Microsoft.Office.Interop.Excel.Workbooks ExcelDoc = ExcelApp.Workbooks;
            Microsoft.Office.Interop.Excel.Workbook MyWorkBook = ExcelDoc.Add(System.Type.Missing);
            Microsoft.Office.Interop.Excel.Worksheet xlSheet = (Microsoft.Office.Interop.Excel.Worksheet)MyWorkBook.Worksheets[1];
            ExcelApp.DisplayAlerts = false;
            ExcelApp.Visible = false;
            
            int i,j;
            for (i = 0; i < 1280; i++)
            {
                xlSheet.Cells[i + 1, 1] = EventRecordArr[i, 0];
                xlSheet.Cells[i + 1, 2] = EventRecordArr[i, 1];
                xlSheet.Cells[i + 1, 3] = EventRecordArr[i, 2];
                xlSheet.Cells[i + 1, 4] = EventRecordArr[i, 3];
                if (i % 2 == 1)
                {
                    for (j = 1; i < xlSheet.Columns.Count; j++)
                        ((Microsoft.Office.Interop.Excel.Range)xlSheet.Cells[i, j]).Interior.ColorIndex = 15;
                }
            }
            Microsoft.Office.Interop.Excel.Range excelRange = xlSheet.get_Range(xlSheet.Cells[1, 1], xlSheet.Cells[1280, 4]);
            excelRange.EntireColumn.AutoFit();
            xlSheet.SaveAs(xlsxfileName);
            ExcelDoc.Close();
            ExcelApp.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelApp);
            ExcelApp = null;
        }

运行时程序卡住，一暂停就停在
((Microsoft.Office.Interop.Excel.Range)xlSheet.Cells[i, j]).Interior.ColorIndex = 15;
这一行

[xdashewan]

for (j = 1; i < xlSheet.Columns.Count; j++)

看出区别了吗

[xdashewan]

引用 1 楼 xdashewan 的回复:

for (j = 1; i < xlSheet.Columns.Count; j++)

看出区别了吗

for (j = 1; i < xlSheet.Columns.Count; j++)

[CypressXT]

无语。。。一定是 昨天夜里手剁坏了

[CypressXT]

引用 2 楼 xdashewan 的回复:

[quote=引用 1 楼 xdashewan 的回复:]

for (j = 1; i < xlSheet.Columns.Count; j++)

看出区别了吗

for (j = 1; i < xlSheet.Columns.Count; j++)[/quote] 无语。。。一定是 昨天夜里手剁坏了