Data import from excel

Hello, I have imported a matrix from excel in matlab. There are 15000 columns and some of them include not only numbers but also some characters (for example: 1532F484). Do you know any way to group all these columns and change the target type from number to cell? Because I don't think I can do it manually for every column.
Thanks

回答 (1 件)

Nobel Mondal
Nobel Mondal 2015 年 8 月 18 日

1 投票

You could read the entire spreadsheet as cells, like this -
>> [~,~,rawData] = xlsread('mySpreadSheet.xls');

カテゴリ

ヘルプ センター および File ExchangeData Import from MATLAB についてさらに検索

質問済み:

2015 年 8 月 18 日

回答済み:

2015 年 8 月 18 日

Community Treasure Hunt

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

Start Hunting!

Translated by