reading from excel file and spliting
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
KSSV
on 20 Jun 2018
[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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!