Please enable JavaScript to view this site.

A-Shell Reference

Utility program LIBXLIAR (source online here) prompts you to load an XLS and then queries it, displaying various details about the workbook such as the number of sheets, rows, cols, pictures, etc. It then prompts you for individual cells to query. You may find it useful both in the same vein as the previous utility—i.e. for examining the contents of spreadsheets that you created or received from others—as well as an example of the use of several LibXL functions related to querying.

As an example, using the same sample invoice referenced previously, here is a query of the contents of cell 7,2 …

ashref_img60