Creating M-file using Excel/Visual Basic

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 个)

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by