Automatic import of Spread sheet data

2 次查看（过去 30 天）
Paul
Paul 2014-9-15
评论： Iain 2014-9-16
Hi,
I am dealing with a spreadsheet which is linked to Bloomberg and therefore it is updating like every 1 min or so. I would like to find a way how i can automatically import the spreadsheet into a Matlab table every time the Spreadsheet data changes. Any suggestions how i can proceed on this issue?
best regards,

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

采纳的回答

Iain
Iain 2014-9-15
It is possible to use a macro in excel that will tell matlab, in some way, if it has been updated.
It is also possible to just check the spreadsheet, from matlab, every "n" seconds. ("pause" & xlsread, being the commands you'd want)
It is also possible to control the spreadsheet's operation from matlab via an active x server.
  6 个评论
显示 4更早的评论
Paul
Paul 2014-9-15
编辑：Paul 2014-9-15
tic & toc, or "now" or "clock" might give you better timing control than pause. Pick the right tool.
where would i put these commands you are referring to?
Iain
Iain 2014-9-16
It depends what you're doing.
This:
tic
do stuff
a = toc;
Makes "a" store how long it took to "do stuff".
now & clock both return the current time, so you can calculate how long it took to:
a = now; or clock...
do_stuff
b = now; or clock...
time_taken = b-a;
With those you can make sure you only read the excel file at specific times. (say, once every minute, at 25 seconds.)

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by