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.