MATLAB: Reading from excel file and spliting

excelsplitting

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..

Best Answer

 [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
Related Question