How to convert xls to mat file ?

650 次查看（过去 30 天）
sagar
sagar 2014-3-4
评论： Walter Roberson 2019-12-18
I want to convert xls file to mat file
  4 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2019-12-18
Use readtable() to get a table structure.

请先登录，再进行评论。

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

回答（3 个）

ES
ES 2014-3-4
%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 个评论
显示 1更早的评论
Tuffahatul Ummah
Tuffahatul Ummah 2016-9-21
AllData={txt;num};%as you want what txt and num mean? i don't have clue for what must I fill it

请先登录，再进行评论。

Andreas Goser
Andreas Goser 2014-3-4
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 2014-3-4
I have already xls file with 6 column and it contain numeric and string data. So I want to convert into mat file..

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by