Excel Library/API for RTC?
One answer
I'm not sure if I understand your question. If you are looking into downloading work items from Excel via a macro, I would suggest to consider Jazz Reporting Service, which does that natively.
Check this out:
(It's a bit old but still applicable, I think).
Comments
Thanks for that, but not quite right.
I would need to understand the business goal behind such a specific requirement to give you a proper answer, because there are several possibilities. I can think of:
- Write a vba program to make OSLC calls to retrieve the work items, as explained in your original post. That requires some considerable effort.
- Use CURL or write a program to download automatically those multiple queries as csv, then merge them to an Excel file using a macro.
- Use JRS, as I suggested in my previous post. In my opinion, this would be the most elegant solution (and also effortless).