Read data using xlsread and store in a variable
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Muhammad Usman
el 20 de Mzo. de 2015
Respondida: XueJing Yu
el 20 de Mzo. de 2015
Hi I have an Excel file with 1000 rows and i want to pick 30 random rows from it, i used xlsread command to read the excel data in for loop, i want to save all the rows read from the file but the issue i am facing is that when i save in a MAT file (using save command) i just only the last row that overwrites all other rows. please answer quickly,i am very thankful
0 comentarios
Respuesta aceptada
XueJing Yu
el 20 de Mzo. de 2015
Maybe you can read all data and then select rows using function "resample".
data = xlsread(yourFileNameHere);
nTotalRows = 30;
nSelection = 10;
selectedRowIndex = datasample(1:1:nTotalRows,nSelection,'Replace',false);
dataSelection = data(selectedRowIndex,:);
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!