In working with the Spreadsheet Add-in, I wanted to be able to capture a historical listing of data received during my application testing. I would just like to setup filters for various topics and as payloads are received have it fill down the spreadsheet with data updates.
Unfortunately the way the Add-in works you have to subscribe to the updates are isolated to a specific cell which subscribes to it by formula
I checked into the VBA capability to see if there is a way to retrieve data real time using a formula to pull topics, however, the only thing the VBA does is give you functions to start monitoring and do manual updates to a worksheet. Is there nothing that will allow me to pull data real time and capture the historical set? (note I did see the history option capability, but it is only gives you last 4 per topic, I want the whole run)
Thanks,
-TK
Hi,
You can configure an arbitrarily deep history. To do that you need to modify the Qos configuration that the Spreadsheet add-in loads. By default it is 4 and that's why you cannot set it higher.
To configure a larger history depth, do the following.
<qos_profile name="DefaultProfile"> <datareader_qos> ... <history> <kind>KEEP_LAST_HISTORY_QOS</kind> <depth>4</depth> ... </history> ... </datareader_qos> ... </qos_profile> </qos_library><depth>, set a value larger than 4.Let me know if this works for you.
Best,
Alex