Thank you for using Syncfusion products.
XlsIO does not have direct methods to achieve the functionalities like ‘Selection.End(xlDown).Select’. But, this can be achieved through a workaround and we have shared the workaround sample in the following link. Kindly try this and let us know if this helps.
Please let us know if you have any queries.
I'm facing the same issue but I'm not able to download the sample solution that you've provided. Can you please give me the access for the above sample solution.
Greetings from Syncfusion.
We have prepared the sample to fetch the last cell. Kindly try this and let us know if it helps.
FileStream inputStream = new FileStream("Sample.xlsx", FileMode.Open);
IWorkbook workbook = excelEngine.Excel.Workbooks.Open(inputStream);
IWorksheet worksheet = workbook.Worksheets;
IRange cell = worksheet.Range["A1"];
IRange usedRange = worksheet.UsedRange;
var lastcell = "";
int col = cell.Column;
for (int row = 1; row <= usedRange.LastRow; row++)
if (!worksheet[row, col].IsBlank)
lastcell = worksheet[row, col].AddressLocal;
lastRow = row;
The complete sample can be downloaded from the below link.