📘 Excel Line Splitter

🔍 Detailed Description

Excel Line Splitter is a powerful OutSystems extension that allows you to split large CSV and XLSX files into smaller, manageable chunks based on a specified number of lines. It’s ideal for scenarios involving:

• Batch processing
• Integration with external systems
• Memory optimization

The extension automatically detects the file type (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 boolean parameter Header, each output file will include the same header as the original, maintaining data structure for downstream processing.

⚙️ Key Features

• 📄 Line-based file splitting
• 🧾 Optional header preservation
• 📥 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

🚀 How to Use

1. Import the extension into your OutSystems environment.
2. Use the public action BreakLinesByCountwith the following parameters:
   • CSV: the original file (CSV or XLSX)
   • BREAK: number of lines per generated file
   • HEADER: boolean to indicate whether the header should be preserved
3. Receive as output a list of binary files (List<BinaryData>) ready to be downloaded or used in integrations.
4. 

🧪 Tested On

• OutSystems 11+
• CSV and XLSX files with up to 100,000 lines