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.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
Syntax
C#
Copy
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