Hi Team, We are trying to load huge amount of transactions into excel. We tried loading the data with CacheFolder option to load the data. We have endup with issues again. We are in high priority PROD, please help us to resolve ths issues. We are trying to load more than 798709 records in one worksheet and loading 40K records in other worksheets.
ASPOSE.TOTAL FOR .NET DEVELOPER
Error details: System.OutOfMemoryException:
Exception of type 'System.OutOfMemoryException' was thrown. at System.Number.FormatInt32(Int32 value, String format, NumberFormatInfo info) at System.Int32.ToString() at System.String.Concat(Object arg0, Object arg1) at MOCIGuidePost.GuidePost.populateMantasTransactionSheet(Workbook workbook, String epEGID, String reportGeneratedDate, String destfileName, OoxmlSaveOptions saveoptions) in C:\Guidepost\Final Gudepost Code\trunk\Guidepost International Jobs\GP_INTL_PERFORM_ISSUE\MOCIGuidePost\GuidePost.cs:line 1004v