excelDelete
Version 22.0.8473
excelDelete
Version 22.0.8473
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.