如何删除excel中的所有行，除了c＃中的头文件(How to delete all rows from excel except header in c#)

 除了c＃中的标题外，如何删除Excel电子表格中的所有行？ 
 
 我试图使用Microsoft.Office.Interop.Excel;执行此操作Microsoft.Office.Interop.Excel; 图书馆 
 
 我现在有了这个代码 
 
        Range xlRange = ws.UsedRange;
        int rows = xlRange.Rows.Count;

        Console.WriteLine(rows);

        for (int i = 2; i <= rows; i++)
        {
            ((Range)ws.Rows[i]).Delete(XlDeleteShiftDirection.xlShiftUp);
        }
 
 但它并没有删除所有的行，我认为因为当它遇到某个行不再存在行时会删除行，我做错了什么？ 
 
 我设法做到了，我从底部而不是顶部开始，所以现在我的循环是 
 
        for (int i = rows; i != 1; i--)
        {
            ((Range)ws.Rows[i]).Delete(XlDeleteShiftDirection.xlShiftUp);
        }
 
 解 
 
var range = (Range)ws.Range[ws.Cells[2, 1], ws.Cells[ws.UsedRange.Rows.Count, ws.UsedRange.Columns.Count]];
range.Delete(XlDeleteShiftDirection.xlShiftUp);
 
 使用get_Range停止工作时，.Net的v4发生了变化 

How do I delete all rows in an excel spreadsheet except the header in c#?
 
I am trying to do this using the Microsoft.Office.Interop.Excel; library
 
I now have this code
 
        Range xlRange = ws.UsedRange;
        int rows = xlRange.Rows.Count;

        Console.WriteLine(rows);

        for (int i = 2; i <= rows; i++)
        {
            ((Range)ws.Rows[i]).Delete(XlDeleteShiftDirection.xlShiftUp);
        }
 
But it's not deleting all the rows, I think because it's deleting the rows when it hits a certain number that row is no longer there, what have I done wrong?
 
I managed to do it, I have started from the bottom instead of the top, so now my loop is 
 
        for (int i = rows; i != 1; i--)
        {
            ((Range)ws.Rows[i]).Delete(XlDeleteShiftDirection.xlShiftUp);
        }
 
Solution
 
var range = (Range)ws.Range[ws.Cells[2, 1], ws.Cells[ws.UsedRange.Rows.Count, ws.UsedRange.Columns.Count]];
range.Delete(XlDeleteShiftDirection.xlShiftUp);
 
There had been a change in v4 of .Net that using get_Range stopped working

原文：https://stackoverflow.com/questions/42647466