public static IRange SetValue(this IRange range, double?value, bool autoNumberFormat = false) { if (value != null) { //Dumps the object to cell range if (!autoNumberFormat) { range.Value = value; range.SetNumberFormat(NumberFormat.Text); return(range); } range.Value = value; range.NumberFormat = value.GetNumberFormat(); } return(range); }