Big data excel file
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
hello all I need to process big excel file. I imported the excel file to matlab using "dataset" function. now i would like to separate the imported data to columns. I Want that every column will be separate array from the all imported data. can someone advise me, with which matlab function i should use. i found function called "splitapply", is it the right function for me? it will be wonderful if some one will give me an example as well. i attach the excel file i use for the data importing.
0 comentarios
Respuestas (1)
Image Analyst
el 29 de Mayo de 2016
To read in
[numbers, strings, raw] = xlsread(filename);
To extract column 3 into it's own variable, do this:
col3 = raw(:, 3);
2 comentarios
Image Analyst
el 1 de Jun. de 2016
Try using the code I gave you, which DOES have raw mentioned in it.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!