reading from excel file and spliting

Question

shrisha tv 2018-6-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406485-reading-from-excel-file-and-spliting

评论： KSSV 2018-6-20

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

KSSV 2018-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406485-reading-from-excel-file-and-spliting#answer_325400

在 MATLAB Online 中打开

 [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 个评论
显示 2更早的评论隐藏 2更早的评论

shrisha tv 2018-6-20

this is a error Error using xlswrite (line 226) Invoke Error, Dispatch Exception: Source: Microsoft Office Excel Description: Microsoft Office Excel cannot access the file 'C:\Program Files\MATLAB\R2017a\testing data\F7C90520'. There are several possible reasons:

• The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook. Help File: C:\Program Files (x86)\Microsoft Office\Office12\1033\XLMAIN11.CHM Help Context ID: 0

Error in spliting1 (line 7) xlswrite(['filew1',num2str(i),'.xlsx'],A);