I need to modify the value of a column using Epplus

287 Views Asked by At

I need to modify the value of a column First I look for the column by its name, getting the index. I would like to see how I can modify the value of that column based on its ID, or on the contrary, on its range

public static class EpPlusExtensionMethods
{ 
    public static int GetColumnByName(this ExcelWorksheet ws, string columnName)
    {
        if (ws == null) throw new ArgumentNullException(nameof(ws));
        return ws.Cells["1:1"].First(c => c.Value.ToString() == columnName).Start.Column;
    }
}

int columnId = ws.GetColumnByName("Birthdate"); 
0

There are 0 best solutions below