Programmatically getting the last filled excel row using C#

by

Couple ways, 

using Excel = Microsoft.Office.Interop.Excel;

Excel.ApplicationClass excel = new Excel.ApplicationClass();
Excel.Application app = excel.Application;
Excel.Range all = app.get_Range("A1:H10", Type.Missing);

OR

Excel.Range last = sheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing);
Excel.Range range = sheet.get_Range("A1", last);

int lastUsedRow = last.Row;
int lastUsedColumn = last.Column;

More Related Contents:

  1. How to detect installed version of MS-Office?
  2. Export DataTable to Excel with EPPlus
  3. Excel Interop – Efficiency and performance
  4. Format an Excel column (or cell) as Text in C#?
  5. How to write some data to excel file(.xlsx)
  6. Excel to DataTable using EPPlus – excel locked for editing
  7. Fastest way to interface between live (unsaved) Excel data and C# objects
  8. How to read file using NPOI
  9. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  10. Is there any simple way to convert .xls file to .csv file? (Excel)
  11. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  12. How to create CSV Excel file C#? [closed]
  13. How to open an Excel file in C#?
  14. C# create/modify/read .xlsx files
  15. Microsoft.Office.Interop.Excel really slow
  16. How to read single Excel cell value
  17. Get instance of Excel application with C# by Handle
  18. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  19. EPPlus Large Dataset Issue with Out of Memory Exception
  20. Optimal way to Read an Excel file (.xls/.xlsx)
  21. Reading Excel Files as a Server Process
  22. Is csv with multi tabs/sheet possible?
  23. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  24. Reading from Excel (Range into multidimensional Array) C#
  25. How to know if a cell has an error in the formula in C#
  26. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  27. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  28. How to read more than 256 columns from an excel file (2007 format) using OLEDB
  29. Exception (HRESULT: 0x800AC472) when using Excel.Worksheet.Select after calling Excel.Workbook.SaveAs
  30. Running an Excel Macro via C#: Run a macro from one workbook on another?

Leave a Comment