c# - 如何访问excel文件的当前行索引？

Question

public bool StoreInExecel(String name,String csFIleName)
{
    int cellno = ;//Initialize to current row no
    Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
    Microsoft.Office.Interop.Excel.Workbook workbook = (Microsoft.Office.Interop.Excel.Workbook)excelApp.Workbooks.Add(Missing.Value);
    Worksheet worksheet;

    // Opening excel file
    workbook = excelApp.Workbooks.Open(fileName, 0, false, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

    // Get first Worksheet
    worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets.get_Item(1);

    // Setting cell values

    ((Microsoft.Office.Interop.Excel.Range)worksheet.Cells[cellno,"B"]).Value2 = "5";
    ((Microsoft.Office.Interop.Excel.Range)worksheet.Cells[cellno,"B"]).Value2 = "7";

    workbook.Save();
    workbook.Close(0, 0, 0);
    //excelApp.Quit();   
    return true;
}

我想将“cellno”初始化为 excel 文件的当前行索引，这样数据就不会被覆盖。有没有特定的函数来获取填充的行数？

Answer 1

你可以使用

Excel.Range range = (Excel.Range)excelApp.ActiveCell;
int cellno = range.Row;