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!