Borrar filtros
Borrar filtros

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

37 visualizaciones (últimos 30 días)
wendy cruz
wendy cruz el 7 de Jul. de 2017
Comentada: Shamli Kashalkar el 4 de Mzo. de 2021
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?

Iniciar sesión para responder a esta pregunta.

Respuestas (2)

Tanmoy Mohapatra
Tanmoy Mohapatra el 1 de Abr. de 2019
Editada: Tanmoy Mohapatra el 1 de Abr. de 2019
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);
pranati pradhan
pranati pradhan el 23 de Nov. de 2019
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.

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by