I have to build and app that extracts stock exchange data from an excel sheet then save it in a database. The problem is that the excel sheet obtains new data via a Bloomberg plug in.
To refresh the page, the user has to open the spread sheet and hit the refresh button on the plug in in excel. After a second the data is added to the sheet.
i have seen guides about getting or putting data to an excel sheet via java but am not sure how to open the sheet, trigger the update and get the data.
Maybe you can retrieve the data directly with Excel, by using Web Queries. So basically, this feature allows you to get data from the web. You specify the URL, then you select which data on the page you want to import.
You can write these queries in VB as well (ask if you want more details on how to do it with VB).