Hi,
I am using the Workbook.Load function to load up a large spreadsheet containing 100000 rows. This operation is taking a very long time and it appears that the entire contents of the sheet is being read into memory. Is there a more efficient means of achieving this?
Also, please find attached a spreadsheet which kills the Workbook object. A macro needs to be executed in the spreadsheet to generate content. There's a massive button to click on the first worksheet which executes the macro. The following errors are the result:
ContextSwitchDeadlock was detectedMessage: The CLR has been unable to transition from COM context 0x661f00 to COM context 0x662070 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.
And later:
An unhandled exception of type 'System.StackOverflowException' occurred in Infragistics3.Excel.v9.2.dll
Thanks in advance for any assistance provided.
Re-posted to the WinForms forum: https://es.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/42208/performance-on-loading-large-excel-spreadsheet#233475