Big data excel file

1 次查看（过去 30 天）
Moshe
Moshe 2016-5-29
评论： Image Analyst 2016-6-1
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.

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

回答（1 个）

Image Analyst
Image Analyst 2016-5-29
To read in
[numbers, strings, raw] = xlsread(filename);
To extract column 3 into it's own variable, do this:
col3 = raw(:, 3);
  2 个评论
Moshe
Moshe 2016-6-1
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
Image Analyst 2016-6-1
Try using the code I gave you, which DOES have raw mentioned in it.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by