Skip to main content

Exporting Closed Work Items

Closed work items can be exported in Agility while maintaining the distinction between closed and open items.

Overview​

In Digital.ai Agility grids, closed work items display as strikethrough text and open items display as plain text. When items are exported to Excel, the strikethrough formatting is lost and both open and closed items display as plain text. This makes it difficult to tell which ones are closed and which ones are open.

As a workaround, use one of these options to get the list of closed items only.

Option 1: Copy and Paste Closed Items into Excel​

  1. On any page, click the search icon on the header, and click Advanced search.
  2. In the Advanced Search page, select the Deleted check box and then click Search.
  3. Select and copy the items in the grid.
  4. Open a new worksheet in Excel, and click Paste Special. If prompted, choose HTML format.
  5. Save the Excel file to your computer.

Option 2: Use the Digital.ai Agility API​

You can also retrieve closed items by querying the data using the Digital.ai Agility API. This is the best way to retrieve a large number of closed items. To learn more, see Getting Started with the API.

Exporting Grid Data