Click or drag to resize
NanoXLSX

WorksheetSetStyle(Address, Address, Style) Method

Sets the passed style on the passed cell range, derived from a start and end address. If cells are already existing, the style will be added or replaced. Otherwise, an empty cell will be added with the assigned style. If the passed style is null, all styles will be removed on existing cells and no additional (empty) cells are added to the worksheet

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
public void SetStyle(
	Address startAddress,
	Address endAddress,
	Style style
)

Parameters

startAddress  Address
Start address of the cell range
endAddress  Address
End address of the cell range
style  Style
Style to apply or null to clear the range
Remarks
Note: This method may invalidate an existing date or time value since dates and times are defined by specific style. The result of a redefinition will be a number, instead of a date or time
See Also