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

Answers (1)

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

Categories

Asked:

on 18 Aug 2015

Answered:

on 18 Aug 2015

Community Treasure Hunt

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

Start Hunting!