ExcelDna.Integration.ExcelReference.SetValue C# (CSharp) Method

SetValue() public method

public SetValue ( object value ) : bool
value object
return bool
        public bool SetValue(object value)
        {
            return (bool)XlCall.Excel(XlCall.xlSet, this, value);
        }

Usage Example

Example #1
1
    public static void ClearA2B5()
    {
        ExcelReference xlRef = new ExcelReference(1, 4, 0, 1);
        int rows = xlRef.RowLast - xlRef.RowFirst + 1;
        int cols = xlRef.ColumnLast - xlRef.ColumnFirst + 1;
        object[,] values = new object[rows, cols]; // nulls
        xlRef.SetValue(values);

        MessageBox.Show("Done clearing!");
    }
All Usage Examples Of ExcelDna.Integration.ExcelReference::SetValue