如何从命令行将错误列表（或任何自定义查询）从TFS导出到Excel？ [英] How to export bug list (or any custom query) from TFS to Excel from a command line?

问题描述

我需要将错误列表从我们的Team Foundation Server导出到Excel。

I need to export list of bugs from our Team Foundation Server to Excel. It's trivial to do it manually, but I need a command line version since the task needs to be automated.

任何人都知道如何做到这一点？

Anyone knows how to do this?

推荐答案

1. 回答你的原始问题：
   在TFS中添加一个新查询，单击保存。这应该给你一个选项来保存查询在服务器或本地。如果您选择在本地保存，然后将扩展名从WIQL更改为.txt，您将可以使用以下查询： - ）

1. To answer your origional question: Add a new query in TFS, create your query and click save. This should give you an option to save the query either on the sever or locally. If you chose to save it locally and then change the extension from WIQL to .txt you will have the query available to you :-)

意识到您可以选择在Excel /项目功能区中使用团队标记。话虽如此，您可以在excel中创建一个宏，该宏消耗团队功能区上的刷新或发布按钮。查看此示例宏 http://blogs.msdn.com/b/teams_wit_tools/archive/2007/03/15/how-to-invoke-tfs-add-in-controls-from- macro-code.aspx

I hope you are aware that you have the option of using the 'Team' tag in your Excel/Project ribbon. Having said that, you can create a macro in excel that consumes the refresh or publish button on the team ribbon. Have a look at this sample macro http://blogs.msdn.com/b/teams_wit_tools/archive/2007/03/15/how-to-invoke-tfs-add-in-controls-from-macro-code.aspx

HTH。

干杯，Tarun

这篇关于如何从命令行将错误列表（或任何自定义查询）从TFS导出到Excel？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！