How do I prevent excel from opening when using writetable?

3 views (last 30 days)
I am writing multiple tables in a for loop using writetable. Every call to writetable opens a new excel window which is very annoying, not to mention a complete memory hog. Is there a way to prevent this? I just want Matlab to write the file in the background and close it when finished.

Answers (1)

Kevin S
Kevin S on 4 Feb 2020
Of course I would figure out a workaround as soon as I reach out for help.
This issue only occurs if excel is already open. Closing Excel completely prevented any new windows from opening up. It's still not ideal since you can't look at data in Excel while running the Matlab code, but it's something.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!