Exporting Tree to Spreadsheet

XTREE offers the ability to export the tree contents to a spreadsheet via a configurable context menu (right-click or PopupMenu) option. The output format is initially CSV, but there are also options that take advantage of CSV2XL by embedding directives into the CSV file and then passing it through CSV2XL to create an XLS or XLSX output.

See Also:

•   PopupMenu

•   ExportOptions

•   ExportFspec

•   System parameter XTREE options

•   CSV2XL

History

2022 February, A-Shell 6.5.1711:  Exporting to a spreadsheet now supports the footers if XTR.SHOWFOOTER=1. Also, when exporting in the full XLSX mode (see SBR=XTREE_EXPCSV2XLSX), if the Advanced Coldef Parameter Title is defined, it will be used as a banner. The special macro tokens (e.g. %date%) are supported but %page% and %total%—which don't make any sense in the banner of a spreadsheet—are just converted to blanks, as are the justification separators (|).