Big data excel file

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.

Answer 1

[Image Analyst]

To read in

[numbers, strings, raw] = xlsread(filename);

To extract column 3 into it's own variable, do this:

col3 = raw(:, 3);

[Moshe]

Hi,

Thanks for your answer, but it didn't work. I am running this piece of code:

fid ='EUROSTOXX_600_SIM_ALPHA.xlsx'; fid_read=dataset('XLSFIle',fid,'sheet',1); col3 = raw(:, 3);

as you advise me i tried on line 3, but i got this error on the command line in matlab:

"Undefined variable raw."

which else function i can use for my question.

thanks

[Image Analyst]

Try using the code I gave you, which DOES have raw mentioned in it.