Selecting a row of numbers clockwise around a matrix of values

1 次查看（过去 30 天）
Aramis
Aramis 2021-10-20
评论： Image Analyst 2021-10-21
Hi people,
I have an excel file as a matrix of random values (10 rows by 16 columns). I would like to select the value of outer cells, countiniously in clockwise direction (as illustrated in photo starting with cell #1 and ending with cell #17) and paste it as a row of 48 values into a new excel file. My ultimate goal is reading mutiple files in a folder ,and paste the same string row by row in a single excel file.
I appreciate your help and answers for learning and understanding it.

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

回答（1 个）

Image Analyst
Image Analyst 2021-10-20
mTop = m(1, :);
mLeft = m(2:end, end);
mBottom = fliplr(m(end, 1:end-1));
mRight = flipud(m(2:end-1, 1));
outerValues = [mTop(:); mLeft(:); mBottom(:); mRight(:)]
  2 个评论
Aramis
Aramis 2021-10-20
Thanks for your quick awesome reply. Is there any way to make it a bit expanded to read multiple excel files and make an output for all of them in a single file?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by