UtilsGetInternalColumnWidth 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: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc

Syntax

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

Exceptions

Exception	Condition
FormatException	Throws a FormatException if the column width is out of range

Remarks

The internal width deviates slightly from the column width, entered in Excel. Although internal, the default column width of 10 characters is visible in Excel as 10.71. The deviation depends on the maximum digit width of the default font, as well as its text padding and various constants.
In case of the width 10.0 and the default digit width 7.0, as well as the padding 5.0 of the default font Calibri (size 11), the internal width is approximately 10.7142857 (rounded to 10.71).
Note that the column height is not affected by this consideration. The entered height in Excel is the actual height in the worksheet XML documents.
This method is derived from the Perl implementation by John McNamara (https://stackoverflow.com/a/5010899)
See also: ECMA-376, Part 1, Chapter 18.3.1.13

Reference

Utils Class

NanoXLSX Namespace