Write Cell Workbook
Writes a value into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the SheetName value. If a value exists, it is overwritten. Changes are immediately saved.
Input
- Workbook Path: The full path of the Excel spreadsheet that you want to use.
- Type:
System.String - Required
- Type:
- Text: The value to be written to a cell or range.
- Type:
System.String - Required
- Type:
Options
- Password: The password of the workbook, if necessary.
- Type:
System.String
- Type:
Destination
- Sheet Name: The name of the sheet from the workbook
- Type:
System.String - Required
- Type:
- Cell: Specifies the cell to which the input will be written
- Type:
System.String - Required
- Type:
Workbook
- Workbook: The existing workbook instance.
- Type:
DocumentFormat.OpenXml.Spreadsheet.Workbook - Required
- Type:
Details
- This activity can be used even if Excel is not installed in the environment where the process runs.