Please enable JavaScript to view this site.

A-Shell Reference

Navigation: Subroutines > XTREE > XTREE Techniques

Exporting Tree to Spreadsheet

Scroll Prev Top Next More

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:

History

2023 February, A-Shell 6.5.1724: When exporting to XLSX, embedded CRLF's (ASCII 13 plus ASCII 10) are now exported as "^m". Requires CSV2XL 2.1(268) to be effective.

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 (|).