Tranfering excel to mat

1 次查看（过去 30 天）
Bennett Torrance
Bennett Torrance 2017-1-24
编辑： Niels 2017-1-24
I have about 45 data files (all with hundreds of thousands of data points) all in either text format or excel. How to I transfer them from to MAT files in the most efficient way possible? Thanks!

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

采纳的回答

Niels
Niels 2017-1-24
编辑：Niels 2017-1-24
i can think of 1 way, but it can be quite annoying.
you use textscan to read the data from .txt files and xlsread for the excel files. save the data in variables and then use save. the result will be a .mat file. (it may be easier to save them all in the array of one variable)
if the files are located in 1 folder its easier, you can use dir and a for loop

更多回答（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