Question

用c#在excel中符合条件的行上边插入一行？

A B
1 04010118169 3
2 04010118169 4
想要实现的是，当A列相同，B列不同时插入一个空行（即在2上方插入一空行）。一次类推。
代码如下：
static void Main(string[] args)
{
Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Open(@"E:\最短路径\试试.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
excel1.Visible = true;

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];
int i = 2;
if (worksheet1.Cells[i, 2] == worksheet1.Cells[i+1,2])
{
if (worksheet1.Cells[i, 3] != worksheet1.Cells[i+1, 3])
{
Excel.Application ak = new Excel.Application();
ak.Rows.InsertIndent(1);

}
}
i++;
}
请问问题出在哪里，该怎么改？谢谢~

Answer 1

oH~我不会