How to detect data types automatically as in uiimport but without ui?

3 次查看（过去 30 天）
cprogrammer
cprogrammer 2017-11-10
评论： cprogrammer 2017-11-11
When I open the data which consist of string and numbers via Matlab uiimport tool and it automatically detects numeric and string columns correctly but when I read data with readtable, it determines some columns as string even though they are numbers in uiimport. I want a format same as uiimport but do it without user interface(since I have many different csv files). Is there any such function?

请先登录，再回答此问题。

回答（1 个）

ES
ES 2017-11-11
You have tried xlsread on the csv? xlsread can get raw, txt and numbers on different variables.
[NUM,TXT,RAW]=xlsread('mycsvfile.csv')
  1 个评论
cprogrammer
cprogrammer 2017-11-11
I tried it but it produces this error:
Error using xlsread (line 260)
Unable to read XLS file *.csv. File is not in
recognized format.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Whos 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by