I am trying to manipulate large excel file using ClosedXML. Its taking infinite time to process. For example.. deleting 10 columns in a 30MB file, never returned! Has anybody else experienced similar issue for ClosedXML. My code is in C#. Below is sample.
protected void deleteYears(IXLWorksheet ws)
{
// Remove columns
List<IXLColumn> deletecols = (from p in ws.Rows("6").CellsUsed()
where p.Value.ToString().ToUpper().StartsWith("XYZ")
select p.WorksheetColumn()).ToList<IXLColumn>();
foreach (IXLColumn x in deletecols)
{
x.Delete();
}
}
You should implement "better lambdas" https://github.com/ClosedXML/ClosedXML/wiki/Better-lambdas