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.3+c820fb107cc06ae187946bad43db42d71f6faf1c
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