Export DDE / RTD data from Excel to web page possible?
Hi, I would like to know if it is at all possible to create a dynamic web page which displays cell data retrieved from an excel file which is linked to a DDE / RTD data feed (like real time stock quotes), and if an SQL sever would have to be used for it? And if you may have an idea of the maximum amount of money I should expect to pay a web developer for creating such a web page (so I know if someone might be overcharging me)? For example: DDE/RTD data from a program --> Excel --> Access --> SQL Server --> Web Page ? -or- DDE/ RTD from a program --> Excel --> Web Page ? Thanks!
Does Excel do anything with the data or is it just the current method of enabling users to view it? Unless this feed is something really strange, I'm fairly sure any decent web developer would be able to read it and display the data on a page. I doubt that Excel or SQL Server need to be involved. How much money for that? It depends on exactly what type of feed this is, how complicated the data is, and what country you're in. My guess is that it feels like 2 or 3 days work but you haven't given much information to go on.
A few years back I created a small vb script behind the "save" event in excel, and the script uploaded the data to a database(doesn't have to be MSSQL, any DB connected to the website will do), so what happened is that as soon as the user saved their spreadsheet, the web was updated straight away. Had issues with them changing the columns names a couple of times, but once they realised that their web data would break, they stopped doing it pretty quickly. Only took a day to do. but a more robust script (checking columns names etc and not updating if changed) would take a coupleadays.
Sounds like the data might lend itself to [StreamInsight]. StreamInsight is a framework that allows for real time data to be captured into SQL Server, so in your scenario could give you: DDE/RTD data from a program --> StreamInsight --> SQL Server --> Web Page Downsides are that you will need to be on the latest SQL Server version - 2008R2. It doesn't really matter what edition - as the actual code/features/call-it-whatever you like, is just a bunch of DLLs that give you the base on which to build. Might be worth a look, if only just to discard the idea...... :