清空筛选条件
清空筛选条件

Extract data from structure and change it to Numerical matrix

3 次查看（过去 30 天）
Ali Kareem
Ali Kareem 2016-4-28
回答： Azzi Abdelmalek 2016-4-28
Hi,
I have 100 .xlsx files. Each file has 100*100 (row*column).I used blow code to read them.
clear;
clc;
M= 100;
data = cell(1, M);
for k = 1:N
N= sprintf('Data%d.xlsx', k);
data{k} = importdata(N);
end
I have couples of questions
  • How can I plot each column starting from column number 2 against column number1 for all matrices? I should have 99 plot for each matrix.
  • How can I extract data from the structure to do some operation on it? I should have 100 matrices with size (100*100).
I tried below code to extract data, but it isn't working. it is saving only one matrix
for i=1:100
z=data{1,i}.data;
end
I tried this code to make 3D matrix. It will be easier for plotting but when I execute code I got two structures one inside each other and that make extracting data from it difficult
data=zeros(100,100,100)
M= 100;
for k = 1:M
N = sprintf('file%d.xlsx', k);
data(:,:,k)=importdata(N);
end
Thanks

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

采纳的回答

Jan
Jan 2016-4-28
编辑：Jan 2016-4-28
Combine your loops:
data = zeros(100,100,100)
M = 100;
for k = 1:M
FileName = sprintf('file%d.xlsx', k);
FileData = importdata(FileName);
data(:,:,k) = FileData.data;
end

更多回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2016-4-28
M= 100;
data = cell(1, M);
for k = 1:N
N= sprintf('Data%d.xlsx', k);
data{k} = xlsread(N);
end

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by