Excel - Update Rows

Overview

The 'Excel - Update Rows' action updates the specified rows in the Excel file provided.

Input File Types

The following file types are supported:

  • XLSX
  • XLS
  • CSV

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Parameters

The default 'Excel - Update Rows' flow action parameters are detailed below:

  • File Content: A Base64 encoded representation of the Excel file to be processed
  • Row Data: The JSON dataset to be processed and added as rows to the Excel file provided
  • Update from Row: The row number which the data provided will start updating from
  • Update from Column: The column number which the data provided will start updating from

File Contents

Please refer to the Obtaining the 'File Contents' Parameter article for guidance on how to obtain the 'File Content' parameter ready to provide to an Encodian flow action. 

Advanced Parameters

The advanced 'Excel - Update Rows' flow action parameters are detailed below:

Return Parameters

The 'Excel - Update Rows' flow action returns the following data. 

Action Specific Return Values

  • File Content - The processed file (Base64)

Standard Return Values

  • OperationId - The unique ID assigned to this operation.
  • HttpStatusCode - The HTTP Status code for the response.
  • HttpStatusMessage - The HTTP Status message for the response.
  • Errors - An array of error messages should an error occur.
  • Operation Status - Indicates whether the operation has been completed, has been queued or has failed.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk