Graphics

 View Only
  • 1.  Leader Board w/Excel Datalinq

    Posted 03-01-2020 16:54

    I built a leader board that sorts the group information based on scoring, however, the computer I am utilizing doesn't have datalinq service. Is there a way to make this build work without linking the scoring to an excel document?

    Please let me know, I'd greatly appreciate your insight.

    https://www.youtube.com/watch?v=RamDBQHU3tU 

     



  • 2.  RE: Leader Board w/Excel Datalinq

    Posted 03-04-2020 00:29

    Hi Lula,

     

    If you don't have a Datalinq available on your XPression, then you only have two options;

    • either you enter everything manually

    • or you use the API to open a file and read the contents, but I will warn you straight away that you won't be able to open an Excel with it. You'll need a more simple .txt, or .csv-format.

     

    You could use something like this in the OnOnline script:

    Dim FILE_NAME As String = "C:\Test\FileName.txt"
    Dim txtObj as xpTextObject
    dim content as String

    If System.IO.File.Exists(FILE_NAME) = True Then
    Self.getObjectByName("Text1", txtObj)
    content = System.IO.File.ReadAllText(FILE_NAME)
    txtObj.Text = content
    End If

    Hope it helps.


    #XPression


  • 3.  RE: Leader Board w/Excel Datalinq

    Posted 03-22-2020 00:50

    Thank you Kenneth! I appreciate your support!


    #XPression