Write Cell

Writes a value to a specific cell.

This activity writes a value to a specific cell in a user-specified workbook using the Microsoft Graph Update range API.

Input

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

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

• Cell Address: String Argument Specifies the address of the cell to which the data is to be inserted. Input the address in A1-style notation. This property doesn't support range values. For example : "A1:A3".

• Cell Value: String Argument Specifies the value to be written to the cell.

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook whose data are to be 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].