Write Range

Writes a range of cell values to a given Workbook.

This activity writes a range of cell values from a given DataTable 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 written.

• Starting Cell: String Argument Specifies the starting cell address at which the table data are to be written. Input the address in A1-style notation. This property doesn't support range values like "A1:A3".

• 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].

Options

• Add Headers: If set to true, the data table headers are also inserted into the specified workbook. By default, the value is set to true.