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();