Info
此问题已关闭。 请重新打开它进行编辑或回答。
storing test file here
3 次查看(过去 30 天)
显示 更早的评论
just storing a file here
4 个评论
Jan
2022-2-25
@Allen Borrow: Please stop this immediately.
If all members use the forum to store anything, you will find only junk here soon.
回答(1 个)
Arif Hoq
2022-2-25
if you are following this question you can try this code
A=readtable('Bookk.xlsx', 'ReadVariableNames', false);
B=table2cell(A)
% names = split(B,'delimiter',':')
r = strtok(B, ':')
R=[r B];
N=size(A,1);
C=cell(N,1);
for i=1:N
if isequal(R(i,1),{'1 x'})
C{i}=[R(i,2);R(i+1,2);R(i+2,2)];
if i==18
break
end
end
end
matrix=[C{:}]' % if you want with x, y , z value
[token remain]=strtok(matrix,':')
output=strrep(remain,': ','') % if you want without x, y , z value
1 个评论
Arif Hoq
2022-2-25
if you want to visibility also just concatenate here
C{i}=[R(i,2);R(i+1,2);R(i+2,2);R(i+3,2)];
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!