Selecting a row of numbers clockwise around a matrix of values

2 次查看（过去 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 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by