Creating M-file using Excel/Visual Basic

2 次查看（过去 30 天）
Nihal
Nihal 2011-2-9
I have a few Excel files which have a number of graphs and plots. I would like to now convert numeric data within these Excel files into a M-file and then load it within MATLAB.
I would like to automate this process such that at press of a button I can generate an M file.
Is there an existing plugin within Excel or some existing Visual Basic code that can do this?
I have absolute no knowledge of Visual Basic however if there is an example then I can probably suit it to my needs.
Any help or starting point or example would be appreciated.

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

采纳的回答

John
John 2011-2-9
Do you have to use visual basic? In MATLAB you can use xlsread to load in the excel file and then save the loaded data into .mat files.

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