Format Activity
The Format activity converts a specified column within an Excel file to a desired data format. This enables precise data representation for various data types, including dates, text, currency, and time.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name of the MS Excel file that has already been opened or created. | Required |
| Range | Specifies the Excel sheet range from which to fetch data. | Optional |
| Sheet name | The name of the sheet to work in MS Excel. If not specified, the first sheet is used by default. | Optional |
| Sheet index | The index of the sheet to work in MS Excel. If not specified, the first sheet is used by default. | Optional |
| Format | Defines the desired format for cells, supporting dates, text, currency, and time. | Required |
Action Types & Examples
Date Format
- Format: string
- Example Result:
"dd.MM.yyyy"
Number Format (e.g., ID)
- Format: string
- Example Result:
"00000000000"
Text Format
- Format: string
- Example Result:
"@"
Currency Format
- Format: string
- Example Result:
"₺ #, ## 0; -₺ #, ## 0"
Time Format
- Format: string
- Example Result:
"hh.mm: nn"
Implementation Examples
Field Setup - Excel name: ${formatExcel} - Range: A1:C5 - Sheet name: Sheet1 - Sheet index: 5
Execution Parameters - Format (Date): dd.MM.yyyy - Format (Number/ID): 00000000000 - Format (Text): @ - Format (Currency): ₺ #, ## 0; -₺ #, ## 0 - Format (Time): hh.mm: nn
Technical Notes
The activity supports a wide range of custom and predefined Excel format codes. Users can extend the provided examples or leverage standard Excel number formats to achieve specific data representations.