excelInsert

Version 22.0.8473


excelInsert

Version 22.0.8473


Append a record to an Excel sheet.

必要なパラメータ

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

オプションのパラメータ

  • 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 です。
  • 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.デフォルト値は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.デフォルト値は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

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