Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Handling Huge Excel by Chunking Logic
by Enquero Inc
2
Snippet
67
Summary
Summary
Overview
Overview
In the schenario of having an Excel file with more than 10 million records and the need to apply some sort of filter condition for each and every record, this component helps to read the huge Excel file and convert each sheet into separate Excel files. Then, based on the chunk size (like 2.5lac Excel records as 1 chunk), loop through each newly created Excel file and convert it into small chunk XML documents.
In general, when UiPath is trying to access and load entire bulk Excel files into a single datatable and performing datatable activities like sorting, merging, filtering, it throws an "out of memory exception" issue, because UiPath is trying to access more RAM (32 bit application can access only 4gb RAM). In this situation, users can benefit from this snippet to process Excel files chunk by chunk.
Features
Features
1. Provides logic to handle and process huge Excel files
2. Resolves the "out of memory exception" issue by processing bulk Excel files by chunking logic.
Additional Information
Additional Information
Dependencies
Code Language
Visual Basic
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.1Updated
Jan 10, 2022Works with
Studio: 21.10.4 - 22.10
Certification
Silver Certified
Tags
Handling_Huge_Excel
Excel Automation
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
