 | Utils Class |
General Utils class with static methods
Inheritance HierarchySystemObject
NanoXLSXUtils
NanoXLSXUtils
Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
SyntaxC#
public static class Utils
The Utils type exposes the following members.
Constructors
Methods| Name | Description | |
|---|---|---|
  | GeneratePasswordHash |
Method to generate an Excel internal password hash to protect workbooks or worksheets This method is derived from the c++ implementation by Kohei Yoshida (http://kohei.us/2008/01/18/excel-sheet-protection-password-hash/) |
| GetDateFromOA |
Method to calculate a common Date from the OA date (OLE automation) format OA Date format starts at January 1st 1900 (actually 00.01.1900). Dates beyond this date cannot be handled by Excel under normal circumstances and will throw a FormatException |
| GetInternalColumnWidth | 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 |
| GetInternalPaneSplitHeight | Calculates the internal height of a split pane in a worksheet. This height is used only in the XML documents of worksheets and is not exposed to the (Excel) user |
| GetInternalPaneSplitWidth | Calculates the internal width of a split pane in a worksheet. This width is used only in the XML documents of worksheets and is not exposed to the (Excel) end user |
| GetInternalRowHeight | Calculates the internal height of a row. This height is used only in the XML documents of worksheets and is usually not exposed to the (Excel) end user |
| GetOADateTime | Method to convert a date or date and time into the internal Excel time format (OAdate) |
| GetOADateTimeString | Method to convert a date or date and time into the internal Excel time format (OAdate) |
| GetOATime | Method to convert a time into the internal Excel time format (OAdate without days) |
| GetOATimeString | Method to convert a time into the internal Excel time format (OAdate without days) |
| GetPaneSplitHeight | Calculates the height of a split pane in a worksheet, based on the internal value (calculated by GetInternalPaneSplitHeight(Single)) |
| GetPaneSplitWidth | Calculates the width of a split pane in a worksheet, based on the internal value (calculated by GetInternalPaneSplitWidth(Single, Single, Single)) |
| ToString | Transforms an integer to an invariant sting |
| ToUpper | Transforms a string to upper case with null check and invariant culture |
Fields| Name | Description | |
|---|---|---|
 | FIRST_ALLOWED_EXCEL_DATE | First date that can be displayed by Excel. Real values before this date cannot be processed. |
| FIRST_VALID_EXCEL_DATE |
All dates before this date are shifted in Excel by -1.0, since Excel assumes wrongly that the year 1900 is a leap year. See also: https://docs.microsoft.com/en-us/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year |
| INVARIANT_CULTURE | Constant for number conversion. The invariant culture (represents mostly the US numbering scheme) ensures that no culture-specific punctuations are used when converting numbers to strings, This is especially important for OOXML number values. See also: https://docs.microsoft.com/en-us/dotnet/api/system.globalization.cultureinfo.invariantculture?view=net-5.0 |
| LAST_ALLOWED_EXCEL_DATE | Last date that can be displayed by Excel. Real values after this date cannot be processed. |
| MAX_OADATE_VALUE | Maximum valid OAdate value (9999-12-31) |
| MIN_OADATE_VALUE | Minimum valid OAdate value (1900-01-01). However, Excel displays this value as 1900-01-00 (day zero) |
See Also