Methods for specifying which Excel file and sheet to operate on, and for closing the workbook when done.
Authoring a workbook from nothing: start a file, add the sheets it needs, and write your own rows into them.
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.