xlsread and MATLAB engine timing

2 次查看（过去 30 天）
Caroline
Caroline 2013-7-30
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!

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

回答（1 个）

Kevin
Kevin 2013-7-30
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 个评论
Caroline
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!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by