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