Determining the number of rows in an excel sheet and storing it as value n in MATLAB

Question

wendy cruz 2017-7-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347745-determining-the-number-of-rows-in-an-excel-sheet-and-storing-it-as-value-n-in-matlab

评论： Shamli Kashalkar 2021-3-4

I have an excel sheet named test.xlsx with two columns. I want to figure out the number of rows (not columns) and store that value in n...how to write such a code in MATLAB?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Tanmoy Mohapatra 2019-4-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347745-determining-the-number-of-rows-in-an-excel-sheet-and-storing-it-as-value-n-in-matlab#answer_368429

编辑：Tanmoy Mohapatra 2019-4-1

When you read an excel, it is stored as matrix. knowing dimension of that matrixs will do the work.

[NUM,TXT,RAW]= xlsread('path of your test.xlsx');

[NoOfRows,NoOfColumn]= size(TXT);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

pranati pradhan 2019-11-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347745-determining-the-number-of-rows-in-an-excel-sheet-and-storing-it-as-value-n-in-matlab#answer_402942

How to calculate how many rows are having numeric values and how many rows are empty in a particular cell of an excel sheet.I have to consider only one column of an excel sheet and find how many rows of that column are having numeric values.Please help me with this.