Excel Functions

This section contains helper functions that you can use for reading and writing Excel files.

excelAddRow — Adds a new row to a sheet in a workbook.
excelAddSheet — Adds a new sheet to the open workbook.
excelCloseWorkbook — Saves and closes the workbook that was opened at the beginning of the process.
excelGetCell — Gets the string value from the specified cell.
excelOpenWorkbook — Opens a workbook so that it may be used in the script.
excelRemoveRow — Removes a row in the opened workbook.
excelRemoveSheet — Removes the selected sheet from an open workbook.
excelReplaceRow — Clears the specified row without impacting the index of any rows beneath of it.
excelSetCell — Updates the value of the specified cell in the open workbook.
excelSetCurrentSheet — Specifies the current sheet by name or index that subsequent processes should use.