-
November 24th, 2019, 03:24 AM
#1
realtime live data from excel to SQL server
Hi,
i am new to this tool, and i am wondering if it can help me doing the following .
basically i want to capture any cell changes in an excel spreadsheet and update a sql server database with the corresponding data .
any idea is welcome .
thanks
-
November 25th, 2019, 09:25 AM
#2
Hi issam1975,
If the excel spreadsheet run on a client machine (maybe you have multiple of this clients) and the SQL Server on a server-side machine, use of Lightstreamer makes sense.
In the client-side you need to capture the change events with MS Office library available - as far as I know, in different languages for example c#, VB, Java - this is outside the scope of Lightstreamer.
At this point you can develop a simple client using one of our client libraries that connects to the Lightstreamer server, and every time you get a new value for a cell executes a sendmessage that transfers the data to the server.
At the server side you only need to specialize our basic Metadata Adapter, to implement clients authentication and write all received messages into the db.
Please let us know if you need any further clarifications.
Regards,
Giuseppe
Similar Threads
-
By HassanShehata in forum Client SDKs
Replies: 14
Last Post: January 6th, 2015, 07:43 PM
-
By Alessandro in forum Client SDKs
Replies: 0
Last Post: November 24th, 2010, 04:01 PM
-
By minhphan200677 in forum Adapter SDKs
Replies: 1
Last Post: July 30th, 2007, 11:02 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
All times are GMT +1. The time now is 04:02 PM.
Bookmarks