Enquero is a technology solutions company helping enterprises in their digital transformation journey. Founded in 2014 and headquartered in Silicon Valley, USA, we have more than 600 members spread across 8+ locations worldwide. We drive innovation through a creative mix of cutting-edge technology and technical know-how to solve our customer problems efficiently. Our focus has always been on the digitization of organizations through the integration of information, skills, and experience. At Enquero, we're helping our customers appreciate what's feasible, assess what's important, and execute what's meaningful. Our people and platform are the keys to doing this successfully.

42b0a651-eac6-4732-9826-f9e8e285b5b3.png

9ac2186a-b66f-47c1-8aac-c04e55505ac6.jpg

RPA developer

99602728-0337-4557-abc5-ce34c773e1d4.zip

52f23d31-23a3-4459-8e05-ba96b946363d.png

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.

This snippet takes the bulk Excel file as input and converts it into small xml based on the chunk size (total records in chunk).

1963173d-5b38-4409-a9dd-7331d6b5e350.jpg

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Handling Huge Excel by Chunking Logic