_Tech Mahindra Limited is an Indian multinational provider of information technology (IT), networking technology solutions and Business Process Outsourcing (BPO) to various industry verticals and horizontals._

dec1a6fa-d1c3-4666-a277-35ccde5dd603.png

Senior Software Engineer

When we write a large amount of datatables in a workbook in an Excel application, it takes a very long time and it often fails due to memory exception error. To avoid this situation, we are dividing the datatable into smaller datatables according to the required size, before writing the data in Excel.

Due to this the data will be written without any memory exceptions and the processing time will also be faster.

Divide a bigger Datatable to a list of smaller Datatables with specific Data size