You can also use Microsoft Excel and Microsoft Project to connect to TFs by using the following methods:
- Connect to TFs through Microsoft Excel. After team explorer is installed, Microsoft Excel will have an additional team menu:
Excel 2007
Excel 2003
- Click "new list" or "New List". A message is displayed, indicating that you have connected to the TFS server. After the connection is successful, the project selection list of the team is displayed:
- Select the team project for which you want to create a work item. For example, select the tfsstudy project and click OK:
- In, We need to select whether to modify by querying the existing information or directly entering the new work item. Generally, we select the existing information for modification:
- For example, after selecting all tasks, click OK:
- We can see that all task information created in the tfsstudy Project template has been read into the Excel table. Now we can use the familiar EXCEL to modify the information, for example, we add a new development task with the title "add a task in Excel ":
- Then, we will release the modification to the TFS server. You can use the "publish" or "publish" button in the team menu:
- After the release is successful, we can use team explorer to view the new task:
- Connect to TFs through Microsoft Project and open the project. There is also a "team" or "team" menu, depending on whether the project version is Chinese or English, a toolbar for TFs operations is also added:
- Click "Select Team Project" on the toolbar. If this is the first connection, a message is displayed, indicating that the TFS user information is entered. Then, a list of projects on the corresponding TFs server is displayed to select a team project, perform the following operations:
- Here, we select the tfsstudy project and click OK. Then we found that the "get work item" button on the toolbar becomes available:
- Project support for TFs is more powerful than Excel:
- In, you can select an existing query in the tfsstudy project to obtain relevant information and edit it:
- You can also specify a work item to modify it separately:
- You can even provide titles and types of work items for fuzzy search:
- Here, we select to query "My work items in all team projects" and click the search button to display the search results:
- You can also select which work items to edit and select through the check box before the work items. Click OK. The query result is displayed in the project list:
Double-click a work item in the list to edit it using the project. After editing, click the "publish" button on the toolbar to synchronize the editing work to the TFS Server:
