excelInsert

Version 20.0.7681


excelInsert

Version 20.0.7681


Append a record to an Excel sheet.

Required Parameters

  • sheet: The name of the Excel worksheet.
  • 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’.
  • RowId: The index of the row appended to the document.
  • dataType#: The data types you want to set to the range.
  • allowformula: If true, the cell value that starts with an equals sign (=) will be treated as a 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

  • sheet: The name of the Excel worksheet updated.
  • RowId: The index of the row appended to the document.