The CSV to Excel Converter component provides functionality to convert CSV data into an Excel file format (XLSX) programmatically. It supports different text encodings for CSV input and allows customization of the delimiter used in the CSV file. This component is designed to be easily integrated into OutSystems applications, enabling efficient handling and conversion of CSV data into a structured Excel format for reporting or further processing.

Features:

• CSV to Excel Conversion: Converts CSV data, whether in UTF-8 or UTF-16LE encoding, into a well-structured Excel workbook (XLSX).

• Customizable Delimiters: Supports any delimiter (e.g., commas, semicolons, tabs) to split the CSV content into columns.

• Text Encoding Support: Automatically detects and handles different text encodings (UTF-16LE and UTF-8), making it adaptable for various CSV file formats.

• Output as Byte Array: Returns the Excel file as a byte array, suitable for saving, downloading, or sending via an API.