Click or drag to resize
PicoXLSX

LowLevel.GetInternalColumnWidth 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.2+f55916d49ef2baa43fc7dc8f5c7d751a77c50baf
Syntax
C#
Copy
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