Add row to Excel

Adds or inserts a row to an excel file.

Excel to Datatable designer

Properties#

Excel to Datatable properties

Input#

  1. File Path The path on disk from where to load/save the excel file.
  2. Row Data The array of cell values to be set on the row. It can be represented as {"abc", 1, 2, "last Cell"}.
  3. Row Index The row index where the row should be inserted, in case we want to insert a row. By default, it is -1, which means the row will be added to the end of the file.
  4. Sheet Name The name of the sheet where the row will be added/inserted.

General Properties#

See General Properties.

Misc#

See Misc.

Out Error#

See Out Error.