Update cells in an Excel worksheet.

Required Parameters

• sheet: The name of the Excel worksheet.
• RowId: The index of the row updated to the document.
• cell#: The cells you want to update.
• value#: The values you want to set to the range.

Optional Parameters

• version: The version of Excel you are using. The allowed values are ‘AUTO, 95, 97-2003, 2007’. The default value is ‘AUTO’.
• file: The path to the Excel workbook.
• handle: The handle for the Excel file.
• headerlocation: Location of the column headers. The default value is ‘NONE’.
• allowformula: If true, the cell value that starts with the equals sign (=) will be treated as formula. The default value is ‘true’.
• recalculate: If true, the cell formulas that depend on the changed cells will be recalculated. If not, they will be calculated on the first opening in Excel. The default value is ‘true’.
• Ignorecalcerror: If IgnoreCalcError is set to True any errors that occur due to formula calculation will be ignored. If this happens the formula result may be unreliable but other data will be accurate. The default value is ‘false’.
• logfile: The log file used to log any errors that occurred during the calculation.
• CloseFile: Indicates whether to close the file now or wait until the connection is closed.

Output Attributes

• file: The name of the Excel workbook updated.
• sheet: The name of the Excel worksheet updated.
• range: The cell range updated.