Excel Line Splitter is a powerful OutSystems extension designed to split large CSV and XLSX files into smaller, manageable chunks based on a specified number of lines. This is especially useful for scenarios involving batch processing, integrations with external systems, or memory optimization.

The extension automatically detects the file format (CSV or XLSX) and processes it accordingly. For XLSX files, it uses the ClosedXML library to ensure compatibility with Microsoft Excel and generate valid spreadsheet files.

A key feature of this component is the ability to preserve the original header row across all generated files. By enabling the Header boolean parameter, users can ensure that each output file includes the same header as the original, which is essential for maintaining data structure during downstream processing.

?? Key Features

• Automatic file type detection (CSV or XLSX)
• Line-based file splitting
• Optional header preservation
• XLSX generation using ClosedXML
• Output as a list of binary files ready for download or further processing

?? Use Cases

• Splitting large datasets for API consumption
• Preparing data for paginated imports
• Reducing memory load during file handling
• Ensuring consistent structure across multiple data files

This extension is lightweight, easy to integrate, and ideal for developers looking to streamline data handling workflows in OutSystems applications.