Excel
The Excel plugin contains functions for opening, reading from and writing to Excel sheets:
- ExcelOpen: To keep an Excel spreadsheet open for speeding up large numbers of write operations.
- ExcelPoke: To set specific cell values at specific cell references in a sheet.
- ExcelRead: To read data from an Excel spreadsheet file.
- ExcelReadBulk: To iterate over the rows of a (potentially large) sheet without having to define the columns at design time.
- ExcelReadHeader: To read the column names of a sheet.
- ExcelWrite: To add (write) a row of data to an Excel spreadsheet file.