Write Data Table To Excel
Writes given data table to given Excel file.
Input
- Sheet Name: The name of the page where the operation will take place
- Type:
System.String
- Type:
- Data Table: The data table where the data is located
- Type:
System.Data.DataTable - Required
- Type:
- Destination Cells: The range where the operation will take place
- Type:
System.String
- Type:
Options
- Append: If checked, it adds the data from the data table to the existing data in the Excel file. If unchecked, it starts writing from the first row of the Excel file.
- Type:
System.Boolean
- Type:
- Exclude Headers: It does not write the header information from the data table to the Excel file when checked.
- Type:
System.Boolean
- Type:
- Batch Size: The data within the data table is split based on the entered value. For example, if a table containing 70000 rows is given a batch size of 10000, the data will be divided into 7 batches. The minimum value that can be entered is 1000.
- Type:
System.Int32
- Type:
Details
- This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.