Importing data from multiple sheets

2020 5 17
1 个回答
回答已采纳
更新时间：2020 5 17
2 次查看（30 天）

0 个投票

Hi everyone!
I have an excel file with 44 sheets, each with a 56x16 matrix. Does anyone know how I can import the first column of each sheet as an 2464 (=44*56) element column vector? And how to repeat this for each column, so I'd end up with 16 column vectors?
The range of the first column is B2:B57, second column is C2:C57 etc., and the sheetnames are country codes.
Thank you in advance!!

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

 采纳的回答

darova
darova 2020-5-17

1 个投票

Use for loop
B = [];
for i = 1:50
A = readmatrix('data.xlsx',i);
B = [B A(:,1)];
end

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by