Import data with several sheets
显示 更早的评论
Dear All,
I have a 2464x2464 matrix for 14 years saved in an excel file. Each working sheet represent one year including the same matrix, such that the data points change over time. I do not have specific time variables included, just the data. How i can import the whole matrix and make Matlab understand it such that i can use the matrix and calculate the development of the rows over time without creating 14 datasets?
Thanks in Advance
采纳的回答
Mathieu NOE
2021-1-2
hello Victoria
happy new year first !
this little piece of code will import evry sheet and stack the data , I assumed you want to have them stacked vertically
it assumes the number of columns are the same in every sheet
% Importing Data from excel across multiple sheets and filenames.
filename = 'file.xlsx';
[~,sheet_name]=xlsfinfo(filename)
data_all = [];
for k=1:numel(sheet_name)
[data,TXT,RAW]=xlsread(filename,sheet_name{k})
% stack data vertically
data_all = [data_all ; data];
end
4 个评论
Victoria Pake
2021-1-4
Mathieu NOE
2021-1-4
hello Victoria
ok - I misunderstood the output format
this is the correct code for what you ask for :
% Importing Data from excel across multiple sheets and filenames.
filename = 'file.xlsx';
[~,sheet_name]=xlsfinfo(filename)
data_all = [];
for k=1:numel(sheet_name)
[data,TXT,RAW]=xlsread(filename,sheet_name{k});
% export to matlab 3D matrix
matrix(:,:,k) = data;
end
Victoria Pake
2021-1-4
Mathieu NOE
2021-1-4
You're welcome !!
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
