Click or drag to resize
PicoXLSX

LowLevelGetInternalColumnWidth Method

Calculates the internal width of a column in characters. This width is used only in the XML documents of worksheets and is usually not exposed to the (Excel) end user

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.5+6ab75fa9edd66571b0de8e574b48108101297ca1
Syntax
C#
public static float GetInternalColumnWidth(
	float columnWidth,
	float maxDigitWidth = 7f,
	float textPadding = 5f
)

Parameters

columnWidth  Single
Target column width (displayed in Excel).
maxDigitWidth  Single  (Optional)
Maximum digit with of the default font (default is 7.0 for Calibri, size 11).
textPadding  Single  (Optional)
Text padding of the default font (default is 5.0 for Calibri, size 11).

Return Value

Single
The internal column width in characters, used in worksheet XML documents.
See Also