Append Range

Appends data to a given excel workbook.

This activity appends data from a given data table to a user-specified excel workbook using the Microsoft Graph Update range API.

Input

• Connection Id: GraphServiceClient Variable Required Specifies the office 365 connection id.

• Datatable:DataTable Variable Required

  Specifies the table of data that is to be written to a specified workbook. We can use the output variable of the Build DataTable activity as input.

• Sheet Name: String Argument Required Specifies the name of the sheet in which data is to be appended.

If the user-specified worksheet doesn't exist within the given excel workbook, then the activity will create a new worksheet with the same name given in the Sheet Name property.

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook whose data are to be written or modified. We can also specify the output variable of the Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook activity (Workbook). If we are using the Results property of the Find Files And Folders activity then we can directly specify the element in the array. For example : Results[1].