Any good ways to read data from messy Excel files?

1 次查看（过去 30 天）
TingTing
TingTing 2015-11-23
评论： per isakson 2015-11-23
Hi, I have some data in Excel files. They include variable names and variable contents (usually a column or a row) and some are two-dimension tables. They are spread in many sheets and files and not often in the same location of different sheets. So the usual xlsread, which is location-specific, does not help much. Is there a good way of reading them from Excel sheets? I know if they had been in text files, we can do low-level file I/O. However, if I export my data into text file, it will be even more messier... So I need some low-level import from Excel directly...
  2 个评论
dpb
dpb 2015-11-23
There's always the third optional return from xlsread that is the raw data as all textual information you can then parse to locate what's of interest...

请先登录，再进行评论。

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

回答（0 个）

类别

在 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