Please enable JavaScript to view this site.

A-Shell Reference

Navigation: Subroutines > XTREE > XTREE Techniques

Exporting Tree to Spreadsheet

Scroll Prev Top Next More

Updated October 2025; see History

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

2025 October, A-Shell 7.0.1779:  Images (other than icons) are now included in the export to Excel. Requires CSV2XL.SBX 2.2(311).

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