How to convert xls to mat file ?

I want to convert xls file to mat file

[Kan-Hua]

To convert a xls file to a mat file, you need to decide the data structure. What Matlab data structure do you want to use for storing your xls file? numerical array? cell array? or table?

[s k]

yes numerical array

[Surendar Kumar Kodali]

need the table structure .

[Walter Roberson]

Use readtable() to get a table structure.

Answer 1

[ES]

%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

[deep]

This helped me :)

[Andreas Goser]

Then vote it up :-)

[Tuffahatul Ummah]

AllData={txt;num};%as you want what txt and num mean? i don't have clue for what must I fill it

Answer 2

[Andreas Goser]

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.

[aman slamaa]

how write Andreas? please type your steps

Answer 3

[sagar]

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