c# - 如何使用 .net 或 vba 在 excel 中使用的范围末尾插入新行？

Question

我的范围值包含 Excel 工作表的已用范围值，现在我无法在范围区域的末尾插入行

 static public void SpreedsheetOpen(string ExcelFile)
    {
        xlApp = new Excel.Application();
        xlApp.Visible = false;
        xlWorkBook = xlApp.Workbooks.Open(ExcelFile, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
        xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
        xlRange = xlWorkSheet.UsedRange;        
    }

在这个 xlRange=xlWorkSheet.UsedRange;我得到了 xl 工作表在范围对象中使用的范围值如何在此范围的末尾插入新行。

Answer 1

Dim LastRow As Long, x As Long

'Select your range
xlRange.Select

'determine the last row of the selection/range
x = Selection.Rows(1).Row
LastRow = Selection.Rows.Count + x - 1

'Select only the last row
Rows(LastRow).Select

'Insert a new row under the selected row
Selection.Offset(1).EntireRow.Insert