Only read data once (with xlsread)
7 ビュー (過去 30 日間)
古いコメントを表示
Hi there,
I am using xlsread to import data from Excel. This takes quite some time, but that's ok. The real problem is that Matlab loads the data whenever I run the script. Hence, whenever I change a few variables and run the whole script, I have to wait minutes because matlab is working on re-loading the data using xlsread.
Is there any way to only load the data ONCE and not every time I run the whole script?
Any help is much appreciated. Thank you very much.
Best Christian
0 件のコメント
採用された回答
Star Strider
2015 年 5 月 3 日
If the Excel file never changes, one option is to save the data in it as a .mat file. Those are smaller to store and faster to load.
Another option is to create your script as a function and store your Excel file as a persistent variable, then calling your function from a new external script file. Running it as a function instead of a script has disadvantages as well, so consider those and decide if that is an acceptable tradeoff for loading your Excel file each time.
6 件のコメント
Star Strider
2015 年 5 月 3 日
My pleasure!
The .mat files are binary files, so they’re smaller that other file types with the same information, and also load variables into your workspace faster than text or other format files.
その他の回答 (1 件)
Image Analyst
2015 年 5 月 3 日
Yes. You can make a GUI with two buttons and a few other controls to change variables (input parameters). One button will run a function that loads the data. Then the other one will get the various settings of your input parameters and run the analysis code.
Also go over the Mathworks video tutorial on using GUIDE: http://blogs.mathworks.com/videos/category/gui-or-guide/
6 件のコメント
Image Analyst
2015 年 5 月 3 日
Glad my/our mat file suggestion (3 comments up) worked for you. Though you can only Accept one, perhaps you could also "Vote" for my answer too.
参考
カテゴリ
Help Center および 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!