xlsread - suppress opening Excel window (R2014a)

2 views (last 30 days)
Joe
Joe on 1 Oct 2014
Commented: Image Analyst on 26 Nov 2014
I recently installed R2014a and MS Office Home 2013 64bit.
When I run xlsread, it briefly opens an Excel window (visible to the user). The data loads fine, but this is visually annoying and unnecessary. It also slows the code slightly.
This didn't occur with my previous installation of R2013a with MS Office 32bit. Does anybody know what is causing this? Perhaps it's the new Matlab or the 64bit Excel.
Thanks for the help! Joe
Sample code
xlsread('filename.xls');
  3 Comments
Show 1 older comment
Bruno Pop-Stefanov
Bruno Pop-Stefanov on 1 Oct 2014
Does it do that on any Excel spreadsheet or only on the same one? Can you try with a blank spreadsheet? Does the spreadsheet contain macros (e.g., MATLABINIT)? Are there any errors printed in the Command Window?
Lena
Lena on 25 Nov 2014
I have the same problem working with MS Office Professional Plus 2013 and Matlab 2014b. I tried it with an empty sheet, but the window still opens. Any ideas?

Sign in to comment.

Sign in to answer this question.

Answers (1)

Image Analyst
Image Analyst on 1 Oct 2014
I don't recall observing that. You could always use ActiveX and set the visible property to off before it opens. I have an ActiveX Demo attached.
  4 Comments
Show 2 older comments
Lena
Lena on 26 Nov 2014
I set the visibility property to false, but every xlsread command leads to a short opening and closing of the respective excel worksheet.
Image Analyst
Image Analyst on 26 Nov 2014
Lena, post your code and explanation in a new question. Perhaps it's just happening so fast.

Sign in to comment.

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!