Methods for specifying which Excel file and sheet to operate on, and for closing the workbook when done.
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.
Methods for exporting Excel data to a file, grid, or string variable, and for calculating summary values from a range.
Methods for comparing the content of a range against another file, grid, or range - useful for data validation and reconciliation.