# MATLAB: How to find the first empty row of a .xlsx-file

excelMATLAB

I have a script in which I use writetable() to write data to a row in an excel spreadsheet. I need to get the row number of the next empty row in the file, but I haven't found a solution on this site.
Kind regards
Mikkel

function lastrow = findLastRow(excelfile, sheetname)    %find last used row of an exel workbook    %excelfile: FULL PATH of excel workbook. Required, char vector or scalar string    %sheetname: sheet name or number. optional (default is 1st sheet). char vector, scalar string or scalar numeric    %TODO: add input validation    if nargin < 2        sheetname = 1;    end    excel = actxserver('Excel.Application');    %start excel    cleanup = onCleanup(@() excel.Quit);        %make sure to close excel even if an error occurs. Will also close the workbook if it is open since it never gets modified    workbook = excel.Workbooks.Open(excelfile); %open workbook    worksheet = workbook.Worksheets.Item(sheetname);   %get worksheet    lastrow = worksheet.Cells.SpecialCells('xlCellTypeLastCell').Row;  %get last used row    workbook.Close;end