Transpose multiple columns to one row

4 次查看（过去 30 天）
Luyi Huang
Luyi Huang 2022-3-23
编辑： Matt J 2022-3-23
Hi there,
I have a file with 41 sheets and I'm trying to read data from column o from sheet1. Then I try to transpose that column into a row. And lastly I will repeat the above: reading column o again from sheet2 and transpose column o into the first row following the previous cells. I can't figure out how to add the transpose into my for loop, can anyone help with that?
Here is my code:
num_sheets = 41;
C = []
for i = 3:num_sheets
data = readmatrix('filename',i ,Range="O2:O57");
C = [C data(:,1)];
end
Thanks a lot!!

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

回答（1 个）

Matt J
Matt J 2022-3-23
编辑：Matt J 2022-3-23
num_sheets = 41;
C = cell(1,num_sheets);
for i = 3:num_sheets
C{i} = readmatrix('filename',i ,Range="O2:O57").';
end
C=cell2mat(C);

类别

在 Help Center 和 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