清空筛选条件
清空筛选条件

Looking for multiple string subjects within excel input array

1 次查看（过去 30 天）
Saeid
Saeid 2017-10-25
评论： KL 2017-10-25
I have a table composed of string and numerical entries:
I can read the file using: [NUMM, TEXTT, RAWW]=xlsread('FileName,.xls')
In a large file I want to find all the values related to e.g. "Average Velocity on Highway". Now naturally if I search the exact string it will be easy to find the line number associated with this string and the relevant numerical values on that same line. However, I happen to have many files of more or less the same format but every time there are slight differences in the text part of the array (hyphenation, space, special charcters etc.). It will make it difficult for me to have Matlab read a sequence of files automatically. How I can I perform a search where I can say I need to find the index numbers of a line where the words 'Average' and 'Velcoty' and 'Highway' appear?

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

回答（1 个）

KL
KL 2017-10-25
编辑：KL 2017-10-25
Use readtable! https://de.mathworks.com/help/matlab/ref/readtable.html
It creates a table just like excel (with variable names as well as row names). It is as simple as,
data_table = readtable('filename.xls','ReadRowNames',true)

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by