reading from excel file and spliting
2 次查看(过去 30 天)
显示 更早的评论
hi, I have 50 columns data in Excel file. each column have 5000 data. have to segregate each column 5000 data into separate 100 data * 50 files. it should be done for all 50 columns. manually it is very difficult, whether it is possible using Matlab. if possible please anyone help me..
0 个评论
采纳的回答
KSSV
2018-6-20
[num,txt,raw] = xlsread(myfile) ; % REad data from excel file
[nx,ny] = size(num) ;
pos = 1:nx ;
idx = reshape(pos,[],100) ;
for i = 1:size(idx,2)
A = num(idx(:,i),:) ;
xlswrite(['file',num2str(i),'.xlsx'],A)
end
4 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!