Low |
internal class LowLevel
The LowLevel type exposes the following members.
Name | Description | |
---|---|---|
AppendSharedString | Method to append shared string values and to handle leading or trailing white spaces | |
AppendXmlTag | Method to append a simple XML tag with an enclosed value to the passed StringBuilder | |
AppendXmlToPackagePart | Writes raw XML strings into the passed Package Part | |
CalculatePaneHeight | Method to calculate the pane height, based on the number of rows | |
CalculatePaneWidth | Method to calculate the pane width, based on the number of columns | |
CreateAppPropertiesDocument | Method to create the app-properties (part of meta data) as raw XML string | |
CreateAppString | Method to create the XML string for the app-properties document | |
CreateColsString | Method to create the columns as XML string. This is used to define the width of columns | |
CreateCorePropertiesDocument | Method to create the core-properties (part of meta data) as raw XML string | |
CreateCorePropertiesString | Method to create the XML string for the core-properties document | |
CreateMergedCellsString | Method to create the merged cells string of the passed worksheet | |
CreateMruColorsString | Method to create the XML string for the color-MRU part of the style sheet document (recent colors) | |
CreatePaneString | Method to create the (sub) part of the pane (splitting and freezing) within the worksheet XML document | |
CreateRowsString | Method to create the enclosing part of the rows | |
CreateRowString | Method to create a row string | |
CreateSharedStringsDocument | Method to create shared strings as raw XML string | |
CreateSheetProtectionString | Method to create the protection string of the passed worksheet | |
CreateSheetViewString | Method to create the (sub) part of the worksheet view (selected cells and panes) within the worksheet XML document | |
CreateStyleBorderString | Method to create the XML string for the border part of the style sheet document | |
CreateStyleFillString | Method to create the XML string for the fill part of the style sheet document | |
CreateStyleFontString | Method to create the XML string for the font part of the style sheet document | |
CreateStyleNumberFormatString | Method to create the XML string for the number format part of the style sheet document | |
CreateStyleSheetDocument | Method to create a style sheet as raw XML string | |
CreateStyleXfsString | Method to create the XML string for the XF part of the style sheet document | |
CreateWorkbookDocument | Method to create a workbook as raw XML string | |
CreateWorkbookProtectionString | Method to create the (sub) part of the workbook protection within the workbook XML document | |
CreateWorksheetPart | Method to create a worksheet part as a raw XML string | |
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) | |
EscapeXmlAttributeChars | Method to escape XML characters in an XML attribute | |
EscapeXmlChars | Method to escape XML characters between two XML tags | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) | |
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/) | |
GetHashCode | Serves as the default hash function. (Inherited from Object) | |
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 | |
GetOADateTimeString | Method to convert a date or date and time into the internal Excel time format (OAdate) | |
GetOATimeString | Method to convert a time into the internal Excel time format (OAdate without days) | |
GetSortedSheetData | Method to sort the cells of a worksheet as preparation for the XML document | |
GetType | Gets the Type of the current instance. (Inherited from Object) | |
HasPaneSplitting | Checks whether pane splitting is applied in the given worksheet | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) | |
NormalizeNewLines | Method to normalize all newlines to CR+LF | |
Save | Method to save the workbook | |
SaveAsStream | Method to save the workbook as stream | |
SaveAsStreamAsync | Method to save the workbook as stream asynchronous | |
SaveAsync | Method to save the workbook asynchronous | |
ToString | Returns a string that represents the current object. (Inherited from Object) |
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) |