How to extract a column numerical data as strings?

1 visualización (últimos 30 días)
Leon
Leon el 7 de Abr. de 2020
Comentada: Leon el 7 de Abr. de 2020
I have some data stored in xlsx format. There is always a column data called "Station IDs". Sometimes it is numerical and sometimes it is strings. I'm using readtable to read the xlsx file.
T=readtable('test.xlsx');
My program can automaticall identifically the column numer (n). I can get the whole column of data as:
A = T.(n);
Here is my question. How do I get the column values as strings no matter it is originally numerical or strings.
Thanks.

Respuesta aceptada

madhan ravi
madhan ravi el 7 de Abr. de 2020
A = string(T.(n)); % have to use string(...) :)
  2 comentarios
Leon
Leon el 7 de Abr. de 2020
Many thanks!
It works flawlessly.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Characters and Strings en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by