Interface CellAddressValuePair

Used for setting a collection of cells.

update

When updating a cell the existing value are merged.

To 'revert a value' back to it's original state' set the value to null. For example to remove all styles set the style to null. Setting a value to null doesn't mean that it will be null but rather means that it will revert to the 'defaulted' value. For example setting numberFormat to null will revert it to the default or 'General' for the default Normal style. To clear/revert all values set the update to null.

Remarks

• Some copy operations replace a cell value. This is done by updating with null then updating a second time.
• passing a value as undefined is treated the same as not being passed at all.