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

Respuestas (1)

Nobel Mondal
Nobel Mondal el 18 de Ag. de 2015

1 voto

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

Categorías

Más información sobre Data Import from MATLAB en Centro de ayuda y File Exchange.

Preguntada:

el 18 de Ag. de 2015

Respondida:

el 18 de Ag. de 2015

Community Treasure Hunt

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

Start Hunting!

Translated by