/// <summary>
/// Clears formulas and values from the range.
/// </summary>
/// <param name="range">The Excel range.</param>
/// <param name="attempts">The number of attempts.</param>
/// <param name="intervalMS">The interval between attempts. [ms].</param>
public static void RangeClearContents(Excel.Range range, int attempts = 10000, int intervalMS = 100)
{
Retry.DoTrue(() => TryBool(() => range.ClearContents()), new TimeSpan(intervalMS), attempts);
}
/// <summary>
/// Copies the entire column specified by the range.
/// </summary>
/// <param name="range">The Excel range.</param>
/// <param name="columnCopyOffset">The column copy offset.</param>
/// <param name="attempts">The number of attempts.</param>
/// <param name="intervalMS">The interval between attempts. [ms].</param>
public static void RangeCopyEntireColumnAttempts(Excel.Range range, int columnCopyOffset = 0, int attempts = 10000, int intervalMS = 100)
{
Excel.Range rangeNext = Retry.NotNull(() => Try(() => range.Offset[0, columnCopyOffset].EntireColumn), new TimeSpan(intervalMS), attempts);
Retry.DoTrue(() => TryBool(() => range.Copy(rangeNext)), new TimeSpan(intervalMS), attempts);
}
/// <summary>
/// Writes the value to the provided range.
/// </summary>
/// <param name="range">The Excel range.</param>
/// <param name="value">The value to write.</param>
/// <param name="attempts">The number of attempts.</param>
/// <param name="intervalMS">The interval between attempts. [ms].</param>
public static void RangeWriteValue(Excel.Range range, string value, int attempts = 10000, int intervalMS = 100)
{
Retry.DoTrue(() => TryBool(() => assignValue(range, value)), new TimeSpan(intervalMS), attempts);
}
