Data import from excel

1 view (last 30 days)
saravan1992
saravan1992 on 18 Aug 2015
Answered: Nobel Mondal on 18 Aug 2015
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)

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

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!