We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Running out of memory

Hi,

I'm trying to use this component, just trying to open a .xlsx document with a Datamodel with several tables and some graphs, the data gets refreshed from SQL Server connections. The size of the file is around 12Mb. What happens is that when opening the file the process runs out of memory at around 3.5Gb.

What I'm trying to accomplish is open the workbook, after the data refesh (done after opening the file) change a cell (with the current date and time) and save again the file.

The process can't open the file, I'm doing this:


ExcelEngine excelEngine = new ExcelEngine();


IApplication application = excelEngine.Excel;

application.UseFastRecordParsing = true;

IWorkbook workbook = application.Workbooks.Open(@"C:\TEMP\Filename.xlsx");

IWorksheet sheet = workbook.Worksheets[0];

sheet.Range["C1"].Text = DateTime.Now.ToString();

workbook.Save();

workbook.Close();

excelEngine.Dispose();

   


1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team April 27, 2023 07:36 AM UTC

Hi Victor,


Kindly share the input Excel document and confirm your machine RAM size and Syncfusion XlsIO version, to investigate the query further.


Regards,

Keerthi.


Loader.
Up arrow icon