1 Reply Latest reply: Oct 22, 2010 1:24 PM by Karl Pover RSS

    Loading inline data via automation

    JohnAntG

      I'm trying to figure out whether the above is possible without even having access to the OCX (pending a license). So I've been perusing the documentation and API guide.

      All I want to do is create a QlikView document and load it with some data, all in memory and independent of a server. Something like this would be ideal:

       


      var document = ocxControl.CreateDocument();

      // this doesn't exist - is there an equivalent?
      document.LoadInline(...);


      But I see no LoadInline API. I see a way to do it with the internal scripting engine:

       


      LOAD * INLINE [
      ...
      ];


      So maybe there's a way for me to pass an arbitrary script to the document for execution?

       


      var document = ocxControl.CreateDocument();

      // this doesn't exist - or does it?
      document.Execute("LOAD * INLINE [ ... ];");


      Can anyone tell me whether what I'm trying to achieve is even possible?

      Thanks

        • Loading inline data via automation
          Karl Pover

          Are you looking for something l that I found in the API Guide:

          rem ** add new line to script **
          set docprop = ActiveDocument.GetProperties
          docprop.Script = docprop.Script & "Load * from abc.csv;"
          ActiveDocument.SetProperties docprop

          And then you can reload the document with:

          ActiveDocument.Reload

          Regards.