ClosedXML find last row number

c# excel visual-studio closedxml
Daniel Blois picture Daniel Blois · Jan 31, 2017 · Viewed 17.1k times · Source

I'm using ClosedXML with C# to modify an Excel workbook. I need to find the last row number used but .RowCount() counts how many rows are in the worksheet. So it is returning 1 million rows when there are only a few thousand. I have tried LastRowUsed() but that doesn't return an int and there is no .row method for it. How can I get the last row in an int?

Answer

Raidri supports Monica picture Raidri supports Monica · Feb 1, 2017

The LastRowUsed() function returns a row object. Use 

worksheet.LastRowUsed().RowNumber()

to get the number of the last row used.

Related questions

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

How can I create an Excel spreadsheet with C# without requiring Excel to be installed on the machine that's running the code?

Read More
How to export DataTable to Excel

How can I export a DataTable to Excel in C#? I am using Windows Forms. The DataTable is associated with a DataGridView control. I have to export records of DataTable to Excel.

Read More
Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've …

Read More