How to convert xls to mat file ?
552 views (last 30 days)
Show older comments
I want to convert xls file to mat file
4 Comments
Answers (3)
ES
on 4 Mar 2014
%get the values in the Excel using xlsread.
[num,txt,raw] = xlsread(filename,sheet,xlRange);
%combine data as you want:
AllData={txt;num};%as you want
%save in mat file
save(matfileName,'AllData');%In your matfile name
3 Comments
Tuffahatul Ummah
on 21 Sep 2016
AllData={txt;num};%as you want what txt and num mean? i don't have clue for what must I fill it
Andreas Goser
on 4 Mar 2014
As of the complexity of what can be in an XLS file, the way to go is to import with XLSREAD, probably postprocess and then write the MAT file with SAVE.
See Also
Categories
Find more on Tables 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!