How to export Work Items with comments to Excel using custom export

Tags: not added yet

The attached example template exportWithComments.xlsx exports comments of the Work items. Each comment will appear in new row.

The key elements of the script is:

The item.attachments collection contains the attachments
Two nested forEach loop is used: the outer goes through the Work items, the inner goes through each items' attachments

The result will be something like this:

[!exportExample.png!]

Please note that text content is exported to Excel in raw format, i.e. wiki text will not be formatted, but its markup code will appear in cells. All other Excel cell limitations apply (e.g. text longer than 3000 chars is truncated). Pictures also will not be exported. Consider using Word export if better formatted export is required.