Use streaming mode (shown above) or break large imports into batches. Also, call workbook.Dispose() explicitly or use using statements.
Here is a simple example demonstrating the ease of use provided by gembox.spreadsheet.dll : gembox.spreadsheet.dll
The library is engineered for speed, claiming to be up to 250 times faster than Microsoft Excel Automation. Use streaming mode (shown above) or break large
worksheet.Cells[2, 0].Value = "Monitors"; worksheet.Cells[2, 1].Value = 5400; worksheet.Cells[2, 2].Value = 6700; 0].Value = "Monitors"
GemBox.Spreadsheet is a registered trademark of GemBox Ltd. Microsoft Excel and .NET are trademarks of Microsoft Corporation.
dotnet add package GemBox.Spreadsheet