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