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

2 ビュー (過去 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 ExchangeStandard File Formats についてさらに検索

製品

Community Treasure Hunt

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

Start Hunting!

Translated by