用c#在excel中符合条件的行上边插入一行? 30
AB10401011816932040101181694想要实现的是,当A列相同,B列不同时插入一个空行(即在2上方插入一空行)。一次类推。代码如下:staticvoid...
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++;
}
请问问题出在哪里,该怎么改?谢谢~ 展开
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++;
}
请问问题出在哪里,该怎么改?谢谢~ 展开
展开全部
oH~我不会
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询