Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
Using the Split Excel Column step, the data in an Excel spreadsheet's column, which is separated by a delimiter, can be split into more or fewer columns and then displayed in a data grid or converted into a CSV file.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File | The CSV or Excel file to edit. | FileData |
| File Type | Defines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect | CSVFileType |
| Worksheet Number | Determines which worksheet that will be edited | Int32 |
| Delimiter | It determines which delimiter to split the columns at. | String |
| Column (Starts at 1) | The starting column where the values will be inserted. | Int32 |
| Number of Resulting Columns | Specify the expected number of resulting Columns after the current Columns are split. | Int32 |
Outputs
| Property | Description | Data Type |
|---|---|---|
| None | --- | --- |
.png)
Related Information
Training Video:
Dynamic Excel Creation