Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 8.12.0 |
| Location | Data > Excel & CSV |
The Convert CSV to Excel component converts CSV tabular data to the Excel format.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| Ignore First Line | Ignores the first line of the worksheet often used as headers in Excel files. | Boolean |
| Input | The CSV or Excel file to convert. | FileData |
| Skip Blank Lines | Ignores any lines that don't contain any data. | Boolean |
| Try to Format Numbers | Formats numbers in the CSV file. | Boolean |
| Type | Defines the type of file to convert the input file to. Currently, the options are Csv, Excel_xls, Excel_xlsx, and AutoSelect. | CSVFileType |
| Worksheet Name | Defines the Name of the Worksheet. | String |
Outputs
| Property | Description | Data Type |
|---|---|---|
| ConvertCsvToExcel1_Output | The converted file in the specified type. | FileData |
Related Information
Forum Posts:
Convert CSV To Excel
Training Video:
Dynamic Excel Creation
Feature Changes
| Description | Version | Date | Developer Task |
|---|---|---|---|
| Added ability to change the Worksheet Name | 8.12 | Pending Release | [DT-037968] |