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