excelDelete

Version 23.4.8800


excelDelete

Version 23.4.8800


Delete the row by RowId in an Excel worksheet.

Required Parameters

  • sheet: The name of the Excel worksheet.
  • RowId: The start row index to be deleted from the document. Starts from 1.
  • count: The count of rows to be deleted from the document.

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’.
  • 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.