Results 1 to 2 of 2
  1. #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

  2. #2
    Administrator
    Join Date
    Feb 2012
    Location
    Milano
    Posts
    716
    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

  1. DDE Server not updating Excel clients
    By HassanShehata in forum Client SDKs
    Replies: 14
    Last Post: January 6th, 2015, 08:43 PM
  2. New Excel RTD Demo Available
    By Alessandro in forum Client SDKs
    Replies: 0
    Last Post: November 24th, 2010, 05:01 PM
  3. java.sql.SQLException
    By minhphan200677 in forum Adapter SDKs
    Replies: 1
    Last Post: July 30th, 2007, 12:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT +1. The time now is 10:31 AM.