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 个)

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

类别

帮助中心File Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by