excelDelete

Version 21.0.8222


excelDelete

Version 21.0.8222


Delete the row by RowId in an Excel worksheet.

必要なパラメータ

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

オプションのパラメータ

  • version:The version of Excel you are using. The allowed values are ‘AUTO, 95, 97-2003, 2007’.デフォルト値はAUTO です。
  • file:The path to the Excel workbook.
  • handle:The handle for the Excel file.
  • headerlocation:Location of the column headers.デフォルト値は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.デフォルト値はTRUE です。
  • Ignorecalcerror:If IgnoreCalcError is set to True any errors that occur due to formula calculation will be ignored.この場合、式の結果は信頼できない可能性がありますが、他のデータは正確です。デフォルト値は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.