c# - Post Live Data To Excel -

c# - Post Live Data To Excel -

i have been asked create programme in either c++ or c#, choice, utilize fix messaging receive bid/offer prices variety of fx instruments , store info in database. part know how client has told me wants ability open n number of excel workbooks across multiple pcs view historic info view live info coming in.

i have seen in excel 2010 can connect direct sql server retrive info refresh fequency can low every minute. i've thought creating rss feed 1 time again may slow. these guys aren't worried latency think if theres more sec delay may not happy.

is i'm looking accomplish possible?

you might write vb macro accomplish this, such follows:

sub refresh_every_second() ' ' refresh_every_second macro ' ' selection.querytable.refresh backgroundquery:=false application.ontime + timevalue("00:00:01"), "refresh_every_second" end sub

this macro refreshes datasource, calls recursively every second.

note:

to refresh pages, utilize activeworkbook.refreshall you may wish introduce means of stopping macro, such click or keypress.

edit: refresh specific info connection, may use:

activeworkbook.connections("data connection name").refresh

c# c++ excel