How to keep a query constantly updated in Excel?
Hi
I need to constantly extract queries for analysis on Excel.
Is there any other, useful way to schedule the queries export, or updating the Excel file via Excel itself (like updating a data connection) without doing so manually (meaning by export work items to *.csv file)?
Excel can get data from a web page, but when i tried to import the data (from the web UI - that's where the query's link leads to) it failed.
Thanks
Dvir
I need to constantly extract queries for analysis on Excel.
Is there any other, useful way to schedule the queries export, or updating the Excel file via Excel itself (like updating a data connection) without doing so manually (meaning by export work items to *.csv file)?
Excel can get data from a web page, but when i tried to import the data (from the web UI - that's where the query's link leads to) it failed.
Thanks
Dvir
2 answers
If you search the net for EXCEL and REST, you can find several Extensions to EXCEL that allow using REST to call out for data, This would be one possible way to do it. You would have to code the way to access the RTC CCM OSLC and REST servcies yourself as Stephanie suggests above.
Comments
The other way round would be to use the Plain Java Client Libraries or a server process to extract data to .csv files. Some hints here: http://rsjazz.wordpress.com/2012/11/19/using-expressions-for-automation/ and http://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
Comments
Darrell Miller
Apr 25 '13, 3:28 p.m.I am also interested in learning how this may be done....preferably without needing to code Java and such. Is it possible to do this using native functions and features of RTC and Excel?