Format Activity

The Format activity converts a specified column or range within an Excel file to a desired data format. This activity ensures data consistency and proper representation for various data types, such as dates, text, currency, and time, within your Excel operations.

Field	Description	Requirement
Excel Name	The reference name of an already opened or created Excel file.	Required
Range	The specific cell range (e.g., `A1:C5` or `C:C` for an entire column) within the Excel sheet to apply the format.	Optional
Sheet Name	The name of the Excel sheet to work with. If not specified, the activity defaults to the first sheet.	Optional
Sheet Index	The numerical index of the Excel sheet to work with (e.g., `1` for the first sheet). If not specified, the activity defaults to the first sheet.	Optional
Format	The desired format string to apply to the cells (e.g., `dd.MM.yyyy` for dates, `@` for text, `00000000000` for numeric IDs).	Required

Action Types & Examples

Date Format

Format: [string]
Example Result: "15.03.2023" (using dd.MM.yyyy)

Numeric ID Format

Format: [string]
Example Result: "12345678901" (using 00000000000)

Text Format

Format: [string]
Example Result: "Any Text Content" (using @)

Currency Format

Format: [string]
Example Result: "₺ 1,234.50" (using ₺ #, ## 0; -₺ #, ## 0)

Time Format

Format: [string]
Example Result: "14.30:00" (using hh.mm: nn)

Implementation Examples

Field Setup - Excel Name: myReportWorkbook - Range: B2:B10 - Sheet Name: DataSheet - Format: dd/MM/yyyy

Execution Parameters - Excel Name: salesData - Sheet Index: 1 - Range: D:D - Format: ₺ #,##0.00

Technical Notes

The Format activity supports various standard and custom Excel format codes. Users can define specific formats for dates, times, numbers, currency, and text. For advanced formatting needs, refer to Microsoft Excel's custom number format guidelines. The activity applies the specified format to all cells within the defined range or column, ensuring data consistency across the selected area.