Aug 18, 2011 at 9:53 AM
Edited Aug 18, 2011 at 9:54 AM
Thanks for the great tool!
However I run into a serious performance/memory issue. When trying to do the following (simply insert 2 empty rows below a row with "[Data]" value in one of its cells:
var workbook = new XLWorkbook("Report.xlsx");
var ws = workbook.Worksheets.Worksheet("Device Data");
IXLRow psirt_row = ws.Rows().Single(r => r.Cells().SingleOrDefault(c => c.Value.Equals("[Data]")) != null);
It took the library about 0.5 sec to simply open the file, about 3 secs to look up the needed row, another sec to insert two empty rows.
And the call to .Save hung the app altogether.. The memory consumption bumped up to 1.6 Gigs.. CPU usage was about 100% (GC seemingly is trying very hard =) ).
The input file (Report.xlsx) is tiny - 13.9 kBytes in size.
Did I do something wrong?