How to convert xls to mat file ?

552 views (last 30 days)
sagar
sagar on 4 Mar 2014
Commented: Walter Roberson on 18 Dec 2019
I want to convert xls file to mat file
  4 Comments
Surendar Kumar Kodali
Surendar Kumar Kodali on 18 Dec 2019
need the table structure .
Walter Roberson
Walter Roberson on 18 Dec 2019
Use readtable() to get a table structure.

Sign in to comment.

Answers (3)

ES
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
Andreas Goser
Andreas Goser on 16 Mar 2015
Then vote it up :-)
Tuffahatul Ummah
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

Sign in to comment.


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

sagar
sagar on 4 Mar 2014
I have already xls file with 6 column and it contain numeric and string data. So I want to convert into mat file..

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!