Only read data once (with xlsread)

6 次查看（过去 30 天）
Christian
Christian 2015-5-3
评论： Christian 2015-5-4
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

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

采纳的回答

Star Strider
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 个评论
显示 4更早的评论
Christian
Christian 2015-5-3
Wow, works like a charm! :-) Star Strider, you just reduced the data loading time from 5 minutes to 45 seconds :-)) Thank you very much!
Star Strider
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
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.
Here is a good framework to get you started: MAGIC
Also go over the Mathworks video tutorial on using GUIDE: http://blogs.mathworks.com/videos/category/gui-or-guide/
  6 个评论
显示 4更早的评论
Image Analyst
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.
Christian
Christian 2015-5-4
Couldn't have done it without you, Image Analyst :-) I'm fascinated by Matlab and it's incredibly vibrant forum. It took you guys 10 minutes to solve my problem. A problem, I've been struggling with for days!
Thanks again for your help, really appreciate it!

请先登录，再进行评论。

类别

在 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!

Translated by