How to read an excel spreadsheet without the spreadsheet appearing on the screen

I'm using xlsread to read ranges on an excel spreadsheet. It all goes well except that the spreadsheet keeps appearing on the screen when data is being read. Is there a way to prevent it to happen?

Answer 1

[Jan]

This is not the standard behavior of xlsread. So please post your code and show us the reply of:

which xlsread

Which OS and Matlab version are you using?

[Image Analyst]

christophe's "Answer" moved here:

Thanks Jan. I have matlab 2014 on windows 8. It was fine before (ie no spreadsheet appearing on screen) but I've noticed that the spreadsheet was appearing a few weeks ago. Cant say for sure if that has happened after I upgraded to Matlab 2014.

[christophe sailland]

And with the code .... which xlsread C:\Program Files\MATLAB\R2014a\toolbox\matlab\iofun\xlsread.m

data_input=xlsread(filename_input,sheet_input_MR,xlRange_input_MR_param);

[Image Analyst]

You officially marked it as Accepted so you've solved it (or Jan did somehow). What did you do to fix the issue , in case others have your same problem?

Answer 2

[Image Analyst]

You aren't using ActiveX to read it, are you? Because that can happen maybe with that approach if the .visible property is set true. Are you using xlsread() or readtable()? It should not happen with those functions.