Hi,

is there a way to find out, whether the content of the current excel file is reached without referring to the cell's emptiness? I have empty rows inbetween and the size of the file (number of rows) is always different. I want to mark the end of the content (=last filled row).


Thank you.

Hi aheristchi,

In case the number of rows allowed is known, you could set the last line content, based on the limit (in case you use low code solution). Maybe this post can give you a reference: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

Other option (not low code) would be to use an extension to do what you need. See this post here for a C# code reference:

https://code.msdn.microsoft.com/office/Excel-get-last-row-and-fe764cfc

Regards,