Home / Questions / 17335
Accepted
Edgar Diaz
Asked: 2020-07-21 21:46:14 +0800 CST 2020-07-21 21:46:14 +0800 CST

How to know the number of rows that an xlsx file has in c#?

  • 772

I am using this code to get the first cell of the file

Excel.Application excelApp = new Excel.Application();
        excelApp.Visible = true;
        string workbookPath = "c:/Users/Edgar/Desktop/base/Libro1.xlsx";//‪C:\Users\Edgar\Desktop\base\Libro1.xlsx
        Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, true, 0, true, false, false);
        Excel.Sheets excelSheets = excelWorkbook.Worksheets;
        excelApp.Visible = false;
        string currentSheet = "Hoja1";
        Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);







        Excel.Range excelCell = (Excel.Range)excelWorksheet.get_Range("A1", "A1");
        string str = (excelCell.Cells as Excel.Range).Value2;

        MessageBox.Show(str);

but I want to save in a variable the number of rows that are filled in xlsx

c#

1 Answers

  1. Best Answer

    I understand that you did not follow the advice of the other question

    Work with xlsx file without excel opening in c#?

    where we recommend using a library based on open xml

    >>I want to save in a variable the number of rows that are filled in xlsx

    could you use

    Worksheet.UsedRange Property

    then you would

    Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);

Excel.Range range = xlWorkSheet.UsedRange;

int rCnt = range.Rows.Count;
    • 2