 | Utils Methods |
The Utils type exposes the following members.
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 |
See Also