Methods for comparing the content of a range against another file, grid, or range - useful for data validation and reconciliation.
Methods for specifying which Excel file and sheet to operate on, and for closing the workbook when done.
Methods for exporting Excel data to a file, grid, or string variable, and for calculating summary values from a range.
Methods for specifying which cells, ranges, rows, or columns an Excel operation applies to.
Methods for setting, replacing, inserting, prepending, and appending values within targeted cells or ranges.