xlsread and MATLAB engine timing

I am using the MATLAB engine to access the function xlsread through C++. The C++ script calls xlsread multiple times to read various columns of different sheets of the same excel document. And while it works correctly, running it takes a while (about 2 minutes). Does anyone know of a faster way to do this?

Thanks!

Answer 1

[Kevin]

Hey Caroline,

Do you ever access the same sheet on two separate occasions? If so I'd save the sheet as a variable to prevent xlsread from being called again. It seems to be an expensive operation to me.

KD

[Caroline]

Hi Kevin,

Thanks so much for answering me! I'm not sure I understand what you mean by save that sheet as a variable. To clarify, do you mean read in the whole sheet at once, as opposed to reading separate columns at different times, and save the cell array that it returns as a variable?

Thanks again!