Matlab number of rows in excel file
excel, matlab, rows
Solution
If the file is empty, or contains data in only one row, then `.End('xlDown').Row;` will move to the very bottom of the sheet (`1048576` is the number of rows in a Excel 2007+ sheet).
Test if cell `A2` is empty first, and return `0` if it is.
Or use `Up` from the bottom of the sheet
num_rows = sheetObj.Cells(sheetObj.Rows.Count, 1).End('xlUp').Row
Note: I'm not sure of the Matlab syntax, so this may need some adjusting
Problem
is there a command of Matlab to get the number of the written rows in excel file? firstly, I fill the first row. and then I want to add another rows in the excel file. so this is my excel file: I tried: ``` e = actxserver ('Excel.Application'); filename = fullfile(pwd,'example2.xlsx'); ewb = e.Workbooks.Open(filename); esh = ewb.ActiveSheet; sheetObj = e.Worksheets.get('Item', 'Sheet1'); num_rows = sheetObj.Range('A1').End('xlDown').Row ``` But num_rows = 1048576, instead of 1. please help, thank you!