Automatic import of Spread sheet data
1 view (last 30 days)
Show older comments
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,
0 Comments
Accepted Answer
Iain
on 15 Sep 2014
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 Comments
Iain
on 16 Sep 2014
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.)
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!