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.