xlsread and MATLAB engine timing

Question

Caroline 2013-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83548-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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Kevin 2013-7-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83548-xlsread-and-matlab-engine-timing#answer_93121

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Caroline 2013-7-30

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!

请先登录，再进行评论。