reading from excel file and spliting

8 次查看（过去 30 天）
shrisha tv
shrisha tv 2018-6-20
评论： 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..

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

采纳的回答

KSSV
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 个评论
显示 2更早的评论
shrisha tv
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);
KSSV
KSSV 2018-6-20
This is problem with xlswrite......you may store into someother format....

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by